For Sales Teams
Power BI custom visuals for sales
Pipeline by stage, attainment against quota and where deals stall: the sales views a forecast call actually needs.
For Sales leaders, RevOps analysts, sales managers. AI-generated, .pbiviz output, source code yours.
By Nawaf Sharaf · Founder & Reliability Engineer · Updated
This is the team view: everything sales teams build in Power BI, from visuals to page templates. For a single dashboard job in depth (its visuals, DAX measures and prompts), jump to the 2 sales dashboard jobs below.
Sales reporting in Power BI usually starts in the CRM export and ends in a Monday forecast call. The questions are always the same: how much pipeline is there by stage, which reps are on track against quota, where do deals stall, and which territories carry the quarter. Native Power BI covers the basics well: a funnel visual for stage counts, a clustered bar for attainment, a matrix for the rep league table. The friction starts when the sales leader asks for the specific view the team argues about: stage-to-stage conversion with the drop-off called out, a quota bullet per rep with the forecast category as a band, a win-rate grid by deal size and segment that highlights the cells with too few deals to trust.
VizForge turns those descriptions into Power BI custom visuals. Describe the funnel with your stage names and conversion labels, the bullet chart with your forecast categories, the heatmap with a minimum-deal threshold, and the generator writes the TypeScript, type-checks it against the Power BI visuals SDK and packages a .pbiviz you import into Desktop. The visual binds to your model like any built-in chart, so the CRM refresh, row-level security for territories and your existing measures keep working. For the page around it, the free Design Studio has sales layouts with a background, theme JSON and a PBIP project with sample data.
What sales teams need
- Native funnels show stage counts but not stage-to-stage conversion and drop-off in one visual (as of November 2026)
- Quota attainment needs target, forecast category and actual on one bar per rep; a clustered bar with three series is hard to read in a forecast call
- Win-rate tables hide the difference between 2 of 3 deals won and 200 of 300 won; small samples need to be marked
- Territory and rep views have to respect row-level security, so a static export or a screenshot from the CRM doesn't work
- RevOps teams change stage definitions every few quarters; the visual must follow the model, not hard-coded labels
Featured visuals for sales dashboards
Each card links to a full reference page with example prompts, data shape, and DAX measures. Generate any of these in under 5 minutes by describing what you want — no code, no developer time.
Stage funnel with conversion and drop-off between stages.
Example: “Sales funnel from Lead to Closed Won with five stages, value and count per stage, conversion % between stages as labels on the connectors, b…”
Quota attainment per rep with forecast-category bands.
Example: “Bullet chart per sales rep: closed-won bar, commit and best-case as grey bands, quota as a vertical target line, sorted by attainment % desc…”
Win rate by segment and deal size, with small samples muted.
Example: “Heatmap of win rate with segment on rows and deal-size band on columns, cells with fewer than 10 closed deals hatched and muted, labels show…”
Pipeline movement from start to end of the quarter.
Example: “Waterfall of pipeline value from start of quarter: new, pulled in, pushed out, won, lost, ending pipeline. Positive steps in teal, negative …”
Bookings card with gap to target and pace.
Example: “KPI card for quarter-to-date bookings with gap to target, required weekly run-rate for the rest of the quarter and a 13-week sparkline.”
Where opportunities go: stage paths to won or lost.
Example: “Sankey of opportunities from source (inbound, outbound, partner) through stages to Won, Lost or Open, link width by deal value.”
Try one of these prompts
Click any prompt below to start a new visual. The prompt opens in your VizForge workspace pre-filled — edit it before generating, or generate as-is.
Example VizForge prompt
Pipeline funnel with stages Prospect, Discovery, Proposal, Negotiation, Closed Won; show value and count per stage and the conversion % between each stage, with the largest drop highlighted.
Example VizForge prompt
Rep scorecard as bullet charts: closed-won vs quota with commit and best-case bands, one row per rep, sorted by attainment, reps under 50% flagged.
Example VizForge prompt
Win-rate heatmap by industry and deal-size band, colour by win %, cells with fewer than 10 deals shown hatched so nobody over-reads them.
FAQ
Can the visual use the stage order from our CRM?
Yes. Bind a stage sort-order column and say in the prompt that stages follow it. The visual reads the order from the data, so a renamed or added stage appears after the next refresh without regenerating the visual.
Will territory row-level security still apply?
Yes. Custom visuals receive only the rows the viewer is allowed to see, exactly like built-in visuals, so RLS roles defined in the model apply unchanged.
Do I need a custom visual for a basic sales dashboard?
Often not. Native cards, bar charts, the funnel visual and a matrix cover a lot. Use a generated visual for the one view the native set can't draw, and the free Design Studio templates for the page layout.
Can I show forecast categories (commit, best case) without extra measures?
The visual needs a field for the category or one measure per category. If your CRM export has a forecast-category column, bind it and describe the bands in the prompt.
Ready to ship your sales dashboard this week?
5 free credits on signup. No card required. .pbiviz output is yours forever.
Generate your first sales visual →Building for another team? See all teams.
Sales dashboard jobs
Each page goes deep on one dashboard: the recommended custom visuals, the DAX measures behind them and ready-to-paste prompts.
Sales leaders, RevOps, analytics teams
Best Power BI Visuals for a Sales DashboardThe best Power BI visuals for a sales dashboard: pipeline funnel, KPI cards, bullet charts, territory heatmaps and…
CS leaders, account managers, CSM operations
Best Power BI Visuals for a Customer Success DashboardThe best Power BI visuals for customer success — health scorecards, retention cohorts, expansion Sankeys, NPS…
Free sales dashboard templates
Free Design Studio page layouts for these dashboards: background image, theme JSON and PBIP project, no signup.
Sales template
Regional Sales PerformanceGradient header band, large map left, 2×2 KPIs and ranked bars right, accounts table
Sales template
Sales PipelineLeft nav rail, 4 KPIs, full-height funnel, trend over table and donut
Sales template
Sales Rep Quota AttainmentGradient band header, 5 KPIs, full-height rep leaderboard left, quota combo + distribution columns + scorecard right
Operations template
Customer SupportPlain header, gauge + 3 KPIs, trend and category bars, agent table and channel donut
SaaS template
SaaS Metrics: MRR & ChurnGlass header card, stacked KPI column, MRR movement, churn trend + cohort matrix
Design the page around it, free
A custom visual looks best on a designed page. The free VizForge Design Studio lays out a branded report page at Power BI’s pixel size and exports the background image, a theme JSON and a PBIP project. No signup.
Open the free Design Studio →Data sources for sales reports
Where this team's data usually lives, and how to get it into Power BI: connector status, the tables to load and KPIs with DAX.
Connector in Microsoft's list
Salesforce in Power BIGet Salesforce data into Power BI with the Salesforce Objects and Reports connectors
No connector of its own in Microsoft's list
HubSpot in Power BIHubSpot data in Power BI
Connector in Microsoft's list
Dynamics 365 in Power BIDynamics 365 data in Power BI via the Dataverse, Business Central and Customer Insights connectors
No connector of its own in Microsoft's list
LinkedIn Ads in Power BILinkedIn Ads data in Power BI
Connector in Microsoft's list
Snowflake in Power BISnowflake in Power BI with the Snowflake connector
Connector in Microsoft's list
Azure SQL Database in Power BIAzure SQL Database in Power BI with the Azure SQL database connector
All Power BI data source guides
Synoptic panels for sales
Floor plans and site maps with regions coloured by a measure.
Synoptic panel
Retail Store synoptic panelYour POS knows exactly which department is dragging — your dashboard shows it as a bar chart nobody stands in front of.
Synoptic panel
Stadium synoptic panelYour ticketing system knows every section's sell-through — your dashboard shows it as a table that hides which side of the bowl is empty.