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 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.

Show and Tell
Tips and Tricks
  • v-robertq-msft's avatar
    v-robertq-msft
    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.

2 Replies

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support
    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.

    • Mathze03's avatar
      Mathze03
      Helper I
      5 years ago

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