Forum Discussion
dynamic axis for chart
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 |
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
2 Replies
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
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
