Forum Discussion

AartiD's avatar
AartiD
Helper II
10 months ago
Solved

Conditional Quadrant chart in PBI

Hi,   I want to create Bubbles Chart with quadratant categories as "Watch Out", "Concern", "Improving" & "Good". Below is screen shot of Bubble chart in Excel. X-Axis will have QoQ% Growth & Y-Axis...
  • v-dineshya's avatar
    v-dineshya
    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