dynamic axis for chart

[Anonymous]

Hi all. I have 2 different pie charts: Customer Count by Product Version and Customer Count by Region. I want to ideally have only 1 pie chart showing Customer Count and have a horizontal slicer that I can rotate between Product Version and Region. Any ideas?

A snapshot of my data would look like this

Customer	Region	Product Version
A	US	Premium
B	Europe	Normal

Desired result

Region

Product Version

[v-diye-msft · Accepted solution]

Hi @Anonymous 

If you'd like to change the visual displaying based on the slicer, you might check the bookmark to achieve this:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks 

[mahoneypat]

Check out this blog to see how to do it with buttons.

https://powerbi.tips/2019/08/dynamic-visuals-using-buttons/

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat