TL;DR
A quadrant chart in Power BI is a scatter chart split into four zones. You make the split with two reference lines, one on each axis, from the Analytics pane. Shading either side of each line gives the four zones their own colours. No custom visual is needed. Set the lines to the median so the split follows the data rather than a fixed number. The chart draws at most 10,000 points, so plot products or accounts and not raw transactions.
Key Takeaways A quadrant chart is a scatter chart plus two reference lines, so nothing needs to be installed from the marketplace. Shaded areas on reference lines, added in the March 2025 release, are what turn four empty zones into four coloured ones. Median thresholds beat averages whenever a handful of large accounts or products skew the distribution. Power BI will not put a measure in the Legend field well, which is why most published DAX quadrant advice quietly fails. Symmetry shading marks the diagonal where X equals Y and is not a quadrant feature, despite how often it is presented as one. Scatter visuals display at most 10,000 data points, so quadrant charts belong on aggregated entities rather than transaction rows. Watch on YouTube
Power BI Copilot Review 2026: What Works, What Fails, What to Skip
Before you hand a quadrant chart to Copilot and hope, watch Kanerika’s team put Power BI Copilot through real report-building tasks and mark where it genuinely saves time against where it still needs a developer.
The Category Review Where Nobody Can Agree Which Products Are Working Picture a Monday category review. The merchandising lead has a table of 180 SKUs with margin percentage in one column and average discount in another, sorted by revenue. Everyone in the room is reading the same numbers and reaching different conclusions.
Sorting a table answers one question at a time. A buyer wants to know which products carry healthy margin and escape heavy discounting, which is a question about two measures at once.
That is the job a quadrant chart does. Plot the two measures against each other, draw a line through the middle of each, and the 180 rows sort themselves into four groups the room can argue about productively. Power BI builds this with visuals that ship in the box.
What a Quadrant Chart in Power BI Actually Is A quadrant chart is a scatter chart with two threshold lines drawn across it. One vertical line splits the plot on the X-axis measure, one horizontal line splits it on the Y-axis measure, and the intersection creates four zones.
Every plotted item lands in exactly one zone, and the zone tells you which combination of the two measures that item represents. Microsoft’s own scatter chart documentation lists displaying data with quadrants as a standard reason to reach for a bubble chart, so this is a supported pattern.
Quadrant Chart vs Scatter Plot The two are the same visual at different levels of finish. A scatter plot shows you a cloud of points and leaves the interpretation open. A quadrant chart adds the two thresholds that turn that cloud into four named groups.
The thresholds carry the analytical content. Place them at zero and you get a sign chart. Set them to the median and you get a relative ranking of the current selection. Place them at a business target and you get a scorecard.
What Quadrant 1, 2, 3 and 4 Mean Mathematics numbers quadrants anticlockwise from the top right, so quadrant 1 is high X and high Y, quadrant 2 is low X and high Y, quadrant 3 is low on both, and quadrant 4 is high X and low Y. Business reports rarely use those numbers.
Report readers respond to names, not coordinates. Label the top right “Grow” and the bottom right “Fix pricing” and the chart explains itself to somebody who opened it for the first time in a meeting.
Where Enterprise Teams Actually Use Them Product portfolio reviews plotting margin against discount or growth against share. Account management plotting revenue against satisfaction or support cost. Supplier scorecards plotting on-time delivery against defect rate. Marketing reviews plotting campaign spend against pipeline generated. Inventory planning plotting turn rate against carrying cost, which pairs naturally with the kind of visual distinction between different data groups a planner needs at a glance. The four zones of a quadrant chart in Power BI, split by one X-axis and one Y-axis constant line. Three Ways to Build a Quadrant Chart, and How to Pick One Almost every tutorial on this topic teaches one recipe. There are three real approaches in Power BI, and they fail in different places, so the choice matters more than the click sequence.
Pick by what has to be dynamic. If only the picture needs to change with filters, reference lines are enough. If quadrant membership has to drive filtering, tooltips or downstream logic, you need DAX involved.
Approach What it gives you Where it breaks Build effort Native reference lines Four shaded zones, thresholds that can follow the median or a parameter, zero modelling work Quadrant membership exists only visually, so you cannot filter or count by it Minutes Shape or image overlay Full control of colour, gradients and labels for an executive-grade layout Only stays aligned if you lock the axis range, and breaks on every resize or data shift An hour, then ongoing maintenance DAX classification A real quadrant value per item that can drive colour, tooltips, tables and drillthrough Legend will not take a measure, so colouring needs conditional formatting or a calculated column Half a day including testing
Table 1: The three build paths for a quadrant chart in Power BI, and the constraint each one carries. Most production reports end up combining the first and third. Reference lines draw the zones, and a DAX measure supplies the colour and the tooltip text.
Method 1: Build the Quadrant Chart With Native Reference Lines This is the path that needs nothing installed. Everything below lives in Power BI Desktop’s Visualizations and Analytics panes, and reflects the behaviour Microsoft Learn documents as of September 2026.
1. Set Up the Scatter Chart Add a Scatter chart from the Visualizations pane, then fill the field wells. Microsoft’s scatter documentation defines what each well does, and getting them right the first time saves a lot of confusion later.
X Axis takes the first measure, for example Discount %.Y Axis takes the second measure, for example Margin %.Values takes the entity you are plotting, such as Product or Account. This is the field that decides how many dots appear.Size optionally takes a third measure such as revenue, turning the scatter into a bubble chart.Legend optionally takes a category column such as Region. Note that this well takes a column, never a measure.If your chart collapses to a single dot, the Values well is empty and Power BI has aggregated everything into one point. Microsoft’s troubleshooting guidance is to add a field that is unique per point, such as a row ID or an index column, which restores one dot per item. Getting the grain right at ingestion avoids most of these surprises later.
A clean model makes this step trivial. Plotting entity-level measures from a well-built star schema in Power BI avoids the duplicate-grain problems that show up as mysterious extra dots.
2. Add the Two Constant Lines Select the visual, open the Analytics pane , and add one X-Axis constant line and one Y-Axis constant line. Both are supported on the scatter chart.
Each line gives you Color, Transparency, Line style, Position and Data label. Name them something the report reader will understand, because the name is what appears if you switch the data label on.
Every reference feature the Analytics pane offers on a Power BI scatter chart. 3. Shade the Four Zones Shading is what makes it read as a quadrant chart rather than a scatter chart with two lines on it. The March 2025 Power BI release stated it plainly, “You can add shade areas for all reference line types.”
Turn the shaded area on for each line and set the before and after colours. The X-axis line shades left and right, the Y-axis line shades above and below, and where the two overlap you get four distinct tints from two settings.
Keep the transparency high, somewhere around 75 to 85 percent. The zones are background, and dots that disappear into a saturated fill defeat the point of the chart.
4. Push the Lines Behind the Data Set each reference line’s Position to behind. The same March 2025 release note records the behaviour that makes this work, “When the reference line position is set to ‘behind’, the shade area will also be moved behind the chart.”
Skip this and the shading sits on top of your markers, washing out exactly the points a reader is trying to identify.
5. Label the Zones Power BI has no native quadrant label. Three options work in practice, and they trade off differently.
Reference line data labels are the cheapest and move with the line, and the same formatting controls covered in our guide to custom labels in Power BI apply to them, but they sit on the line rather than inside a zone. Text boxes placed over the visual look best and cost you nothing at runtime, though they do not move when a threshold moves. A custom tooltip page carries the most information and shows the zone name only on hover.
For a report that will be read by people outside the analytics team, the text box usually wins. Our own data visualization best practices guidance leans the same way, because a label a reader has to hover for is a label most readers never see.
Kanerika Service
Power BI Implementation and Report Development
Kanerika is a Microsoft Solutions Partner. We build the semantic model, the measures and the report layer together, so a quadrant chart reads the same number every other visual on the page does.
Explore Power BI Services
Method 2: Shape and Background Image Overlays Before reference lines could be shaded, overlays were the only way to colour a quadrant. They still have a place, and they still carry a cost that most tutorials skip.
When an Overlay Is the Right Answer Reach for an overlay when the visual design matters more than the interactivity. Board packs, printed one-pagers and executive summary pages are the usual cases, because the layout is fixed and the axis range is known.
Insert four rectangles from the Insert ribbon, set their fill transparency, and send them behind the scatter visual. A single background image gives you gradients and diagonal treatments that shapes cannot.
Lock the Axis Range First An overlay is positioned in report coordinates and the scatter chart is positioned in data coordinates. They only line up while the axis range stays fixed.
Set an explicit minimum and maximum on both axes in the Format pane before you place a single shape. Leave the axis on auto and the next data refresh will rescale the plot while your rectangles stay exactly where they were.
The Maintenance Bill Locked axes mean outliers get clipped instead of rescaling the view. Page resizing, mobile layouts and theme changes all break alignment, and every one of those is a manual fix.
An overlay is a design decision that carries an ongoing maintenance cost. Budget for it. On a report that many people open on many screen sizes, reference lines age far better. The same durability argument runs through most business analytics visualization decisions.
Method 3: Classify Every Point With DAX Reference lines draw zones. They do not tell the model which zone anything is in, so you cannot filter to “products in the danger zone” or count them in a card. DAX closes that gap.
Checklist
Power BI Readiness Checklist
Thresholds, measures and model grain are the three things that decide whether a quadrant chart is trustworthy. Work through the same checks our consultants run before a Power BI report goes to a business audience.
Get the Checklist →
Threshold Measures, and Why Median Usually Wins Start with the thresholds themselves as measures, so the split follows whatever the user has filtered to rather than a number somebody typed in 2024.
Margin Median =
MEDIANX (
ALLSELECTED ( 'Product'[Product Name] ),
[Margin %]
)
Discount Median =
MEDIANX (
ALLSELECTED ( 'Product'[Product Name] ),
[Discount %]
)ALLSELECTED is doing the important work here. It removes the filter that the scatter chart itself puts on each individual dot while respecting the slicers on the page, so every point compares against the same threshold instead of against itself.
Swap MEDIANX for AVERAGEX and you get an average split. Median is the safer default for enterprise data, where a handful of very large accounts or a few deeply discounted clearance lines will drag an average somewhere unrepresentative.
The SWITCH Classification Measure With both thresholds in place, one SWITCH ( TRUE () ) assigns every point its quadrant.
Product Quadrant =
VAR MarginValue = [Margin %]
VAR DiscountValue = [Discount %]
VAR MarginCutoff = [Margin Median]
VAR DiscountCutoff = [Discount Median]
RETURN
SWITCH (
TRUE (),
ISBLANK ( MarginValue ) || ISBLANK ( DiscountValue ), BLANK (),
MarginValue >= MarginCutoff && DiscountValue < DiscountCutoff, "Protect",
MarginValue >= MarginCutoff && DiscountValue >= DiscountCutoff, "Test the discount",
MarginValue < MarginCutoff && DiscountValue < DiscountCutoff, "Review pricing",
"Margin leak"
)The ISBLANK branch matters more than it looks. Without it, products with no sales in the filtered period land in the bottom-left zone and quietly pollute every count a reader takes off the chart.
How four DAX measures turn a scatter chart into a classification the rest of the report can use. The Catch Nobody Mentions Here is where most published advice on this topic stops being true. Nearly every guide tells you to drop that measure into the Legend field well so the four groups get four colours. Power BI will not let you.
The Legend well accepts a column, never a measure, and this is a structural constraint rather than a bug. The visual needs categorical values it can group by before evaluation, and a measure only has a value after evaluation. Dragging Product Quadrant onto Legend simply will not drop.
What Works Instead Three approaches genuinely work, and they suit different reports.
Colour by Field value conditional formatting. Microsoft’s formatting documentation describes three conditional formatting styles, Rules, Gradient and Field value, and notes that Field value “lets you choose a measure or data column in your data model with the color, as a text data type”. Write a second measure that returns a colour and point the marker colour’s fx button at it.
Quadrant Colour =
SWITCH (
[Product Quadrant],
"Protect", "#1B7F3B",
"Test the discount", "#1664DF",
"Review pricing", "#C9A227",
"Margin leak", "#C0392B",
"#9AA5B1"
)This gives per-point colour driven by a live measure, with no Legend at all. The trade-off is that you lose the automatic legend swatches, so you supply the key with a text box or a small matrix beside the chart.
Use a calculated column. A column can sit in Legend, so this restores the swatches and lets users filter by quadrant. The cost is that a calculated column is evaluated at refresh against fixed thresholds, so it will not respond to slicers. Describe it as a segmentation attribute and the label stays honest.
Use a disconnected quadrant table. Create a four-row table of quadrant names, put that column in Legend, and write a measure that returns the axis value only when the selected quadrant name matches the point’s classification. This keeps the swatches and the dynamic thresholds at the cost of the most modelling work of the three.
Three numbers from Microsoft documentation worth designing around before you build. Dynamic Reference Lines That Move With the Data A constant line set to 12 percent is a decision frozen in the report file. Three things can drive that line from the data instead, and they take about the same amount of effort.
Option 1: Statistical Lines From the Analytics Pane The Analytics pane offers Min, Max, Average, Median and Percentile lines on the scatter chart, and each one is bound to a measure you pick from a dropdown. A Median line recalculates against whatever the user has filtered to, with no DAX written at all.
One restriction is worth knowing before you design around it. Microsoft states that the percentile line “is only available when using imported data in Power BI Desktop or when connected live to a model on a server that’s running Analysis Service 2016 or later, Azure Analysis Services, or a semantic model on the Power BI service.” On a DirectQuery model against a plain SQL source, it is not there.
Option 2: A Constant Line Driven by Your Own Measure When the threshold is a business rule rather than a statistic, point a constant line at a measure using the fx button next to its Value. Target margin, last year’s average, a contractual service level, anything the model can calculate.
Keep the measure simple and scalar. A threshold measure that has to scan the fact table for every point will be felt on a large model.
Option 3: A Parameter the Reader Can Drag For scenario work, let the reader move the line. Modeling, then New parameter, then Numeric range creates a calculated table of values, a matching Value measure and optionally a slicer on the page.
Bind the constant line’s value to that measure and the quadrant boundary follows the slider in real time. Two parameters give the reader a movable crosshair over the whole plot. To let readers swap which measures sit on the axes as well, pair this with field parameters in Power BI .
Two documented limits shape how you configure it. A parameter holds at most 1,000 unique values and samples beyond that, so a margin slider from 0 to 100 percent in 0.01 steps will not behave as expected. Microsoft also notes that parameters “are designed for measures within visuals”, so keep them out of dimension logic.
Threshold source Responds to slicers Reader can change it Best for Typed constant No No A fixed rule such as zero margin Median or Average line Yes No Relative ranking inside the current selection Percentile line Yes No Top or bottom decile work on imported models Measure via fx Yes No Targets, budgets and contractual thresholds Numeric range parameter Yes Yes Scenario and sensitivity analysis
Table 2: Five ways to set a quadrant threshold, and what each one buys you. Worked Example: Margin Against Discount Across a Retail Range Back to the Monday category review. A distributor sells 180 SKUs, runs frequent promotions, and wants to know where discounting is buying volume and where it is only buying lost margin. It is the same shape of question that shows up across business analytics examples in retail and distribution.
The worked example below combines the first and third paths, native reference lines plus DAX classification. The Measures Four measures carry the whole chart. Two are the axes, one sizes the bubbles, and one classifies.
Margin % =
DIVIDE ( [Net Sales] - [COGS], [Net Sales] )
Discount % =
DIVIDE ( [Gross Sales] - [Net Sales], [Gross Sales] )
Revenue = SUM ( Sales[Net Sales] )The DIVIDE function is there on purpose. A SKU with no sales in the filtered period returns blank instead of an error, and the ISBLANK branch in the classification measure then keeps it off the chart entirely.
The Build Discount % on the X axis, Margin % on the Y axis, Product Name in Values, Revenue in Size. A Median line on each axis from the Analytics pane, both shaded, both positioned behind the data.
One extra step earns its keep here. Reverse the X-axis so low discount sits on the left, which puts the best-performing products in the top-left corner where a Western reader’s eye lands first.
Reading the Four Zones Zone What it means The action that follows High margin, low discount Selling on merit at full price Protect the listing, secure supply, resist promotional pressure High margin, high discount Margin is surviving the promotion, so the list price may be too high Test a lower everyday price against a shallower discount Low margin, low discount Structurally thin, and discounting is not the cause Renegotiate cost or review whether the line earns its shelf space Low margin, high discount Promotion is consuming the margin Cap the discount depth and measure the volume response
Table 3: The four zones of a margin against discount quadrant, and what each one asks the category team to do. Bubble size finishes the picture. A large bubble in the bottom-right zone is a high-revenue product losing margin to promotion, which is a different conversation from a small bubble in the same place.
Five things the native Power BI scatter chart genuinely cannot do for a quadrant analysis. What a Native Power BI Quadrant Chart Cannot Do Five constraints catch teams out after the chart is already in a report. None of them appears in the tutorials currently ranking for this topic.
Symmetry Shading Is Not Quadrant Shading Symmetry shading appears in the Analytics pane right beside the constant lines, and it is scatter-chart-only, which makes it look purpose-built for this job. It is not.
Microsoft describes it as shading that “highlights the area where X and Y values are equal” and that reveals “which axis measure a data point favors”. That is a diagonal split into two halves, not a cross into four zones. Several popular tutorials present it as a quadrant feature, and it will not give you four zones no matter how you configure it.
Quadrant Membership Is Invisible to the Rest of the Report Reference lines are a drawing on top of the visual. Power BI has no idea a dot is above or below one, so you cannot build a card that counts the products in the danger zone, cross-filter another visual by quadrant, or export a quadrant column. That is the whole reason Method 3 exists.
The Percentile Line Disappears on DirectQuery If your model is DirectQuery against a source other than Analysis Services or a Power BI semantic model, the percentile line is unavailable. Median and Average lines remain, so a median split is the reliable choice for a DirectQuery report.
Points Stop Appearing Past the Ceiling Microsoft is explicit about the limit. “The maximum number of data points that you can display on any type of scatter chart is 10,000.” You set it under Format, then General, then Advanced options, then Number of data points, and Microsoft’s own guidance is to test performance as you approach the maximum.
This is the single most common cause of a quadrant chart that looks wrong. Someone plots order lines instead of products, the visual silently stops at the ceiling, and the zones show a partial picture that nobody notices because the chart still renders.
When a Marketplace Visual Is Worth It Certified custom visuals such as MAQ Software’s Quadrant Chart handle zone shading, naming and thresholds as first-class settings. They are a reasonable choice for a report where the quadrant is the centrepiece and the team has an approved process for marketplace visuals.
Most enterprise teams do not, and a custom visual adds a tenant approval, an update path and a dependency that a native scatter chart does not carry. Build it native first, and reach for the marketplace only when a specific requirement makes the native build genuinely impossible.
Performance and Data Modelling at Enterprise Scale A quadrant chart is cheap to draw and expensive to feed badly. Three modelling habits keep it fast on a real semantic model.
Case Study
60% Efficiency Gain With Microsoft Fabric and Power BI
Allen Distribution had warehouse and HR data stranded in separate on-premises SQL systems. Consolidating both into a Fabric lakehouse with Power BI on top cut report generation time by 95 percent and improved data accuracy by 54 percent.
Read the Case Study →
Aggregate Before You Plot Plot the entity the business talks about, which is almost never the transaction. A category review is about 180 products, not 2.4 million order lines, and the 180-point chart is both faster and more readable.
When the natural grain really is large, add a Top N filter on revenue or another materiality measure. A quadrant of the top 500 accounts tells a clearer story than a fog of 9,000 dots at the ceiling. Where the aggregation happens matters too, and pushing it into the Fabric layer keeps the report thin.
Keep the Star Schema Both axes and both thresholds are measures over the same fact table, filtered by the same dimension. A proper star schema means the engine resolves that in one pass, while a flattened table forces repeated scans over duplicated rows.
If the model is already flat, that is worth fixing before tuning the visual. A clean dimensional model speeds up every visual on the page.
Do Not Scan Twice The classification measure calls two base measures and two threshold measures. Written with variables, as above, each one evaluates once. Written inline inside every SWITCH branch, the same logic evaluates up to eight times per point, and on 500 points that is a visible delay.
ALLSELECTED over a dimension column is also cheaper than ALLSELECTED over the whole fact table. Scope it to the entity you are plotting.
Colour and Accessibility Choices That Survive a Real Audience A four-zone chart leans harder on colour than almost any other visual, which makes it easy to build one a portion of your audience cannot read.
Red and green as the two extremes is the default instinct and the worst choice, because red-green colour vision deficiency is the most common kind. A blue-to-amber scale carries the same good-to-bad meaning and survives every common form of colour vision deficiency.
Do not let colour be the only signal. Power BI’s scatter chart supports marker shapes under Visual, then Markers, then Shape, so a diamond, triangle and square can distinguish groups for a reader who sees the zones as three similar greys. Our walkthrough of marker enhancements in Power BI covers the full set of marker options.
These are the same habits that carry through our wider visualization standards . Two more habits pay off. Turn the shaded areas down to a tint so the markers stay the highest-contrast thing on the canvas, and put the threshold values in the visual subtitle so a reader knows the split is the median of the current selection rather than a fixed number.
How Kanerika Builds Power BI Reporting That Holds Up A quadrant chart is the last five percent of the work. Everything that makes it trustworthy sits underneath it, in the model, the measures and the refresh.
Listen on Spotify
How Do You Build a Powerful Power BI Dashboard?
Kanerika is a Microsoft Solutions Partner, and most of our enterprise Power BI engagements start with the same three problems. The measures disagree between reports, the model is a flat extract rather than a star schema, and nobody is sure which numbers survived the last source system change.
Our delivery sequence handles them in order. We profile the sources and agree the grain, build the dimensional model with the measures defined once and centrally, then layer the report on top with row-level security applied at the model rather than in filters. Report authoring comes last, because a quadrant chart built on contested measures just makes the disagreement colourful. Teams weighing platforms at the same time usually want our Microsoft Fabric and Power BI comparison alongside this.
Allen Distribution is a recent example. The logistics operator had warehouse management and HR data sitting in separate on-premises SQL systems, which meant operational reporting was assembled by hand and nobody had a single view of performance. We consolidated both into a Microsoft Fabric lakehouse with Power BI and row-level security on top, and report generation time was cut by 95 percent alongside a 54 percent improvement in data accuracy.
Teams moving off an older platform hit the same modelling questions on the way in, which is why our Tableau to Power BI and SSRS to Power BI work rebuilds the semantic layer rather than translating visuals one for one.
Wrapping Up A quadrant chart is one of the cheapest analytical upgrades available in Power BI. A scatter chart, two reference lines, shaded areas and a sensible median split take about ten minutes and turn a sorted table into a decision.
The decisions that matter come before the clicks. Whether the thresholds are fixed or follow the data, whether quadrant membership needs to exist in the model or only on screen, and whether you are plotting the right grain. Get those three right and the chart will still be useful a year from now. If the model underneath is the weak link, start with the star schema before you touch another visual.
Talk to Kanerika
Building Analytics Your Business Will Actually Trust?
Our Power BI and Microsoft Fabric teams rebuild the model and the measures first, then the reports. Bring us the dashboard nobody believes and we will tell you what is wrong underneath it.
Book a Meeting →
Frequently Asked Questions
How to create a quadrant chart in Power BI? Add a scatter chart, put one measure on the X axis and another on the Y axis. Put the entity you are comparing in Values. Open the Analytics pane and add an X-axis constant line and a Y-axis constant line. Turn on the shaded area for each line. Then set both line positions to behind the data.
What is a quadrant chart? A quadrant chart is a scatter plot divided into four zones by two threshold lines, one vertical and one horizontal. Every plotted item falls into exactly one zone. The zone shows how that item scores on both measures at once. Teams use it for portfolio reviews, account segmentation and supplier scorecards.
What is a quadrant example? The BCG growth-share matrix is probably the best known example of one. It plots products by market growth rate against relative market share. Products then land as Stars, Cash Cows, Question Marks or Dogs. A retail version plots profit margin against discount depth to find lines where promotion is eating the margin.
How do I shade quadrants in Power BI? Select the scatter chart and open the Analytics pane. Add your X-axis and Y-axis constant lines. Switch on the shaded area for each one and pick a colour for the side before and after the line. Where the two shaded areas overlap you get four distinct tints from two settings.
Can Power BI reference lines be dynamic? Yes, in three ways. Median, average, minimum, maximum and percentile lines recalculate against whatever the user has filtered to. A constant line can be bound to any measure through the conditional formatting button next to its value. A numeric range parameter lets a report reader drag the threshold with a slicer.
How do I create a median line in Power BI? Select the visual, open the Analytics pane and expand the Median line section. Choose Add, name the line, then pick the measure it should follow from the Measure dropdown. The line recalculates whenever filters change, which makes it a better default than a hand-typed constant whenever your data is skewed.
How do I create a quadrant category using DAX? Write threshold measures first, usually MEDIANX over ALLSELECTED of the entity column. Then write a SWITCH measure on TRUE that compares each point’s two values against those thresholds and returns a quadrant name. Add a branch that returns blank when either value is missing, so empty items stay off the chart.
Why will Power BI not let me put my quadrant measure in the Legend? The Legend field well accepts a column, never a measure. Power BI groups by legend values before evaluating measures, so a measure has no value at the moment grouping happens. Colour the points with Field value conditional formatting instead, or switch to a calculated column or a disconnected quadrant table.
How many data points can a Power BI scatter chart display? Microsoft sets the maximum at 10,000 data points for any type of scatter chart. You change the setting under Format, then General, then Advanced options, then Number of data points. Microsoft advises testing performance as you approach that maximum, because chart load time grows with the number of points plotted.
Why are my Power BI scatter chart points missing? Two causes account for most cases. The visual may have hit its data point ceiling, which silently truncates the plot. Or the Values field well is empty, so Power BI aggregates everything into one point. Adding a field that is unique per item, such as a row ID, restores the individual dots.
Can I create quadrant analysis in Power BI without a custom visual? Yes. The native scatter chart plus two constant lines with shaded areas covers almost every requirement. Marketplace visuals make zone shading and naming first-class settings, which helps when the quadrant is the centrepiece of an executive page. They also add a tenant approval step and an update path to maintain.
How do I create a scatter plot in Power BI? Pick the scatter chart from the Visualizations pane. Drag one numeric measure to X Axis and another to Y Axis. Put the entity you want one dot per, such as Product or Account, in the Values well. Add an optional measure to Size to turn the plot into a bubble chart.
What is a quadrant scatter chart? A quadrant scatter chart is the same visual as a quadrant chart. The underlying visual is a scatter plot, and the quadrants come from reference lines drawn across it. The term is common because Power BI has no separate quadrant visual in the box. You build it from the scatter chart.
What is the difference between a scatter plot and a quadrant chart? A scatter plot shows the relationship between two measures and leaves interpretation open. A quadrant chart adds two threshold lines that sort the same points into four named groups. The thresholds carry the analysis. Setting them at the median gives a relative ranking, while a business target gives a scorecard.
What does quadrant 1, 2, 3 and 4 mean? Mathematics numbers quadrants anticlockwise starting from the top right. Quadrant 1 is high on both axes and quadrant 3 is low on both. Quadrant 2 is low X with high Y, and quadrant 4 is the reverse of that. Business reports usually replace those numbers with descriptive names that readers understand faster.
How to make a 4 quadrant graph? Plot your two measures on a scatter chart, then decide where each threshold sits. Add one constant line on each axis at that value from the Analytics pane. Shade the area on both sides of each line so the four zones get distinct colours. Add a text label to each zone.
How does a quadrant chart work? Each point is positioned by two measures, one controlling horizontal placement and one controlling vertical placement. Two threshold lines cut the plot area into four regions. A point lands in whichever region matches its combination of values. Reading the chart means knowing what each axis measures and where the thresholds sit.
How to read a quadrant graph? Start with the two axis labels so you know what is being measured. Then find the two threshold lines and check what value each one sits at. Points in the same zone share a profile on both measures. Bubble size, when used, carries a third measure such as revenue or headcount.
What is a 4 quadrant chart type? A four quadrant chart is a matrix-style visual that sorts items into four groups using two intersecting threshold lines. In Power BI it sits on a scatter plot foundation. Common named versions include the BCG growth-share matrix, the Eisenhower priority grid, and the risk likelihood-versus-impact matrix used in audit reporting.
What is a four quadrant diagram called? It goes by several different names depending on the context. Quadrant chart, matrix chart and four-square grid all describe the same basic shape. Specific business frameworks carry their own names, including the BCG Matrix, the Ansoff Matrix and the Eisenhower Matrix. In Power BI the underlying visual is always the scatter chart.
What are quadrant charts used for? They suit any decision where two measures together determine priority. Product portfolio reviews plot margin against discount. Account teams plot revenue against satisfaction. Procurement plots on-time delivery against defect rate. Marketing plots spend against pipeline generated. The four zones turn a long sorted table into a short list of actions.
