Dynamic X axis and Y axis for Scatter chart

[marcoslepore22]

Hi guys,

I´m kind of new to Power BI. Thanks in advance for your help.

I want to create a dashboard like this:

https://dataveld.com/power-bi-sample-wind-energy-makeovermonday-2019-w08/ 

A "simple" scatter chart with dynamic both X and Y axis (I want to let the final user choose what they want on the axis), just like the example on the link above. I saw ways to do it using bar charts but I couldn´t find something that works on scatter charts for both axis.

Could you please help me?

[marcoslepore22]

The result

[Anonymous]

Hi Marco , This is Awsome! 

it would be great if You share the power bi file. 

[amitchandak · Accepted solution]

@marcoslepore22 , As scatter visual take measure on both axis measure slicer should work

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...
https://www.youtube.com/watch?v=vlnx7QUVYME

[Anonymous]

Hi , 

I applied tow Slicer Measure for each Aixs in Scatter Chart, The problem is When I added A filter Slicer For each Aixs it would effect the other Filter Slicer and would not let me change the filter Value! 

Slicer Measure 1 = SWITCH(SELECTEDVALUE('Indicator'[IndicatorName], "A"),

"A", [indicatorvalues1],

"B", [indicatorvalues1],

"C", [indicatorvalues1]

)

Slicer Measure 2 = SWITCH(SELECTEDVALUE('Indicator'[IndicatorName], "B"),

"A", [indicatorvalues1],

"B", [indicatorvalues1],

"C", [indicatorvalues1]

)

these are the Slicer Measures. 

and for Filter Slicer I just choose the 'Indicator'[IndicatorName],

[marcoslepore22]

I applied these MEASURE SLICERS on the axis values and all worked! Thanks for the help and for the tutorial links!

[marcoslepore22]

Thanks for the reply @amitchandak . I´ll try these measure slicers and then I come back here with the results.