Forum Discussion

Mathze03's avatar
Mathze03
Helper I
5 years ago
Solved

Define quadrant filter for scatter chart / quadrant chart

Hey there,   we use a scatter chart / quandrat chart to visulaize data by two dimension. The axis scales are each from 0 to 4. We have added median lines which divide the chart into 4 quadrants. It...
  • v-robertq-msft's avatar
    5 years ago

    Hi, Mathze03 

    According to your description and sample data, I think that the “What-If” parameter in the Power BI can help you to achieve the filter according to the quadrant.

    For example, if you want to filter the lower left quadrant, you can create two “What-If” parameters and add the slicers like this:

     

    Then you can create a measure like this:

    Flag =
    
    var _maxx=MAX('Parameter x'[Parameter x])
    
    var _minx=MIN('Parameter x'[Parameter x])
    
    var _maxy=MAX('Parameter y'[Parameter y])
    
    var _miny=MIN('Parameter y'[Parameter y])
    
    return
    
    IF(
    
        MAX('Table'[x])<=_maxx&&MAX('Table'[x])>=_minx
    
        &&
    
        MAX('Table'[y])<=_maxy&&MAX('Table'[y])>=_miny,1,0)

    Then you can add the visual filter to this scatter chart like this:

     

    And you can get what you want.

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.