Change dispersion graph axes using filters

[Syndicate_Admin]

Good, I'm working on a personal report.

I have the question about how the axes of the scatter plot can be changed with filters.

That is, every time I want to make a comparison on my scatter plot, I don't have to make a new graph and change the variables of the axes.

Greetings.

[v-jingzhang · Accepted solution]

Hi @Syndicate_Admin 

You are using the same measure on X axis and Y axis of the scatter plot chart. When in a visual, both axises are affected by the same filters outside, so the measure returns a single value ideally. 

In your case, if you want to use two slicers to affect the X axis and Y axis individually, you can use two measures, for example, [0_SELECT VALOR X] and [0_SELECT VALOR Y]. Use two independent measures tables to feed two measures and two slicers. Then both measures will be affected by the relevant slicer separately and return different values. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Syndicate_Admin]

I'm at it.

Thanks a lot.

[amitchandak]

@Syndicate_Admin , As the Axis on scatter plot, are numeric /measures, You can use measure slicer to control that

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

[Syndicate_Admin]

Good again,

I don't know if it's my poor command of the language and my very basic level of Powerbi, but I can't fully understand the explanations.

I think I do have the filters well, but when I change the variable and show it to me in the Scatter Plot, it gives me the same value on the X Axis and on the Y Axis.... and as much as I have tried I can not find out.

I leave some screenshots of what I have done:

That's what I've done and I'm not quite sure it's not even right 😅

Thanks a lot.

I edit to add that I think I have the error in the SCATTER GRAPH, because as I add in the following screenshot, the filters and the values of X axis and Y axis are fine as shown in the tables, but I can not understand because in the scatter plot it shows me in the same value on the two axes.

Thanks a lot.