Define quadrant filter for scatter chart / quadrant chart

[Mathze03]

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 looks like this:

Now we would like to filter by each quadrant. There is no direct option by I thought I could set up a pre-defined slicer for each quadrant. If you want to filter by the lower left quadrant the x & y value should be between 0 and 2.5. When you want to filter for the lower right quadrant the x value should be between 2.6 and 4 and y value equal/between 0 and 2.5. A similar approach would need to be applied for the upper two quadradts. Does anyone know whether there is a way to define such pre-defined slicer for each quadradt? Thank you very much in advance for your help.

[v-robertq-msft · Accepted solution]

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.

[Mathze03]

Thank you very much for your help!!! That is super useful and does the magic!!!