Button to toggle visual axis Count vs Count (Distinct)

Hi j1s

 

Greg_Deckler Thank you for sharing!

 

Yes, you can achieve your goals by creating bookmarks and buttons.

 

Here are the details, please try:

 

 First, you need to create two versions of your stacked bar visual - one using Count and the other using Distinct Count. Ensure these are placed exactly on top of each other on your report page.

 

Next, create two bookmarks in Power BI - one for each visual state (Count and Distinct Count). Make sure to hide one visual and show the other for each bookmark accordingly.

 

 

Finally, insert a button on your report page that users can click to toggle between the two bookmarks (and thus, between Count and Distinct Count).

 

 

 

 

By following these steps, you'll effectively create a toggle mechanism on your report page, allowing users to switch the visual's axis between Count and Distinct Count with a simple click.

 

You can view the link below for more details:

 

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

 

Create buttons in Power BI reports - Power BI | Microsoft Learn

 

Regards, 

Nono Chen 

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