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
- AartiD10 months agoHelper II
Yes, I tried. Pls see my reply its showing Time Intelligence error.