Forum Discussion
Conditional Quadrant chart in PBI
- 10 months ago
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