Forum Discussion
Dynamic X axis and Y axis for Scatter chart
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 , 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/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYME
7 Replies
- amitchandak
Super User
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/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYMEThanks for the reply amitchandak . I´ll try these measure slicers and then I come back here with the results.
I applied these MEASURE SLICERS on the axis values and all worked! Thanks for the help and for the tutorial links!
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],
The result
Could you please explain how you achieved it marcoslepore22 ?
