Swap chart axis by slicer

[Galat198]

Hi,
I have two graphs with different axes

I need to swap on the graph both Y-axis and X-axis according to the slicer choice?

Is this possible ??

[v-henryk-mstf · Accepted solution]

Hi @Galat198 ,

According to your request, you want to dynamically change the values of x-axis and y-axis according to slicer. Because you didn't provide the relevant data, I did a similar test: I created a calculated measure in a calculated table for dynamic X & Y chart changes. Add the Domain column to axis, the created measure to values to get a table, and the Name column to slicer. By filtering different names, the X & Y values change accordingly.

Here is the sample pbix file.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Galat198 , for X-axis you can use a bookmark

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

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