Forum Discussion
Define quadrant filter for scatter chart / quadrant chart
- 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.
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.
- Mathze035 years agoHelper I
Thank you very much for your help!!! That is super useful and does the magic!!!