Quadrant categories coming in Different directions in Power BI Bubble chart

[AartiD]

Hi,

I am facing some issue with Bubble chart divided into 4 Quadrants - Good, Improving, Concern & Watch Out. These categories are defined as per as per conditons below.

Categories	Conditions
Concern	QoQ<HYoHY and both negative; QoQ < -10%
Watch out	QoQ<HYoHY and QoQ > -10%
Improving	QoQ>HYoHY and QoQ < 10 %
Good	QoQ>HYoHY and both positive; QoQ > 10%

Measure used for these conditions:-

Quadrant for Bubble Chart =

SWITCH(TRUE(),

[QoQ Growth (Rolling Avg 3M) %] > [HYoHY Growth (Rolling Avg 6M) %]  && [QoQ Growth (Rolling Avg 3M) %] > 0 && [QoQ Growth (Rolling Avg 3M) %] > 0.1, "Good",              

[QoQ Growth (Rolling Avg 3M) %] > [HYoHY Growth (Rolling Avg 6M) %] && [QoQ Growth (Rolling Avg 3M) %] < 0.1 , "Improving",

[QoQ Growth (Rolling Avg 3M) %] < [HYoHY Growth (Rolling Avg 6M) %] && [QoQ Growth (Rolling Avg 3M) %] > -0.1, "Watch Out",

[QoQ Growth (Rolling Avg 3M) %] < [HYoHY Growth (Rolling Avg 6M) %] && [QoQ Growth (Rolling Avg 3M) %] < 0 && [QoQ Growth (Rolling Avg 3M) %] < -0.1, "Concern")

Since the above is measure and it was not possible for me to create calculated column, I have created Quadrant Paratment by Selecting "New Parametre"- Field.

If you see in below Screen shot in Good Quadrant "Watch Out" Bubble is coming.

Similarly all other categories are coming in different directions.

I have also created avegare of X axis (i.e Average of QoQ Rolling Avg 3 Months%) and Y- Axis (i.e Average of HYoHY Rolling Avg 6 Months%) using below measure, but still result has not change. The Quadrants are created using Text Box.

It would be reaaly helpful if any one can help.

[Kedar_Pande]

Quadrant for Bubble Chart =
SWITCH(TRUE(),
[QoQ] > [HYoHY] && [QoQ] > 0.1, "Good",
[QoQ] > [HYoHY] && [QoQ] <= 0.1, "Improving",
[QoQ] < [HYoHY] && [QoQ] >= -0.1, "Watch Out",
[QoQ] < [HYoHY] && [QoQ] < -0.1, "Concern",
"Other"
)

Use this measure for bubble color, not a parameter. The parameter won't dynamically filter your data points correctly.

[AartiD]

But "measure" I cannot use in Visual, nor I am able to create column for this. I amgetting error of time intelligence. Thats why I created above mesure and added in Field Parametre.

[v-menakakota]

Hi @AartiD ,
Thanks for reaching out to the Microsoft fabric community forum. 

Field parameters are not ideal for dynamically segmenting bubble chart points because they act like slicers rather than measures. That’s why categories are appearing in different directions.

Instead of a parameter, create a disconnected table with the quadrant categories. Then, use a measure to assign each data point to a quadrant based on your conditions. This way, your bubble chart can use the measure for bubble color, and it will dynamically reflect the correct quadrant.

If I misunderstand your needs or you still have problems on it, please feel free to let us know. 

Best Regards, 
Community Support Team 

[AartiD]

Hi,

Can you show and Tell? Measure i am not able take in "Legend" column of scatter chart even if i create disconnected table.

[v-menakakota · Accepted solution]

Hi @AartiD,

You are correct, measures cannot be used in the Legend field of a scatter chart in Power BI, as the Legend only accepts columns. This is why your measure, even with a disconnected table, does not function in that area.

To illustrate, I created a sample table with the columns Category, QoQ, and HYoHY. In the scatter chart.

I assigned QoQ to the X-axis, HYoHY to the Y-axis, and Category to Details.

If you attempt to use a measure for quadrant assignment in Legend, it will not work. Instead.

I created a calculated column:

Quadrant Column = 
SWITCH(TRUE(),
    SampleData[QoQ] > SampleData[HYoHY] && SampleData[QoQ] > 0.1, "Good",
    SampleData[QoQ] > SampleData[HYoHY] && SampleData[QoQ] <= 0.1, "Improving",
    SampleData[QoQ] < SampleData[HYoHY] && SampleData[QoQ] >= -0.1, "Watch Out",
    SampleData[QoQ] < SampleData[HYoHY] && SampleData[QoQ] < -0.1, "Concern",
    "Other"
)

By dragging this calculated column into Legend, the bubbles are now correctly colored according to their quadrants.

If I misunderstand your needs or you still have problems on it, please feel free to let us know. 

Best Regards, 
Community Support Team 

[v-menakakota]

Hi @AartiD ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team 

[v-menakakota]

Hi @AartiD ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team