Forum Discussion
Conditional Quadrant chart in PBI
Hi AartiD .
Thank you for the update. Please try below steps.
1. Quadrant Color measure for bubble coloring
Quadrant Color =
VAR QoQ = [QoQ Growth (Rolling Avg 3M) %]
VAR YoY = [HYoHY Growth (Rolling Avg 6M) %]
RETURN
SWITCH(
TRUE(),
QoQ < YoY && QoQ < 0 && YoY < 0 && QoQ < -0.1, "#FF0000",
QoQ > YoY && QoQ > 0 && YoY > 0 && QoQ > 0.1, "#008000",
QoQ < YoY, "#FFFF00",
QoQ > YoY, "#0000FF",
"#808080"
)
2. Instead of placing the Quadrat category measure in Legend , place the measure in Tooltip.3. Apply Conditional Coloring, Select the Scatter chart.
Go to Format --> Markers --> Colors --> fx (conditional formatting). Set Format style to Field value. Based on field: Quadrant Color. This will color the bubbles based on the quadrant logic.I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
I am not able to put Quadrat category measure in Legend even in Scatter chart.
Hi AartiD .
Thank you for the update. Please try below steps.
1. Quadrant Color measure for bubble coloring
Quadrant Color =
VAR QoQ = [QoQ Growth (Rolling Avg 3M) %]
VAR YoY = [HYoHY Growth (Rolling Avg 6M) %]
RETURN
SWITCH(
TRUE(),
QoQ < YoY && QoQ < 0 && YoY < 0 && QoQ < -0.1, "#FF0000",
QoQ > YoY && QoQ > 0 && YoY > 0 && QoQ > 0.1, "#008000",
QoQ < YoY, "#FFFF00",
QoQ > YoY, "#0000FF",
"#808080"
)
2. Instead of placing the Quadrat category measure in Legend , place the measure in Tooltip.
3. Apply Conditional Coloring, Select the Scatter chart.
Go to Format --> Markers --> Colors --> fx (conditional formatting). Set Format style to Field value. Based on field: Quadrant Color. This will color the bubbles based on the quadrant logic.
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Hi AartiD ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Hi @AartiD ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh