Toggle between percentage value and actual value in the same bar chart

[Anonymous]

Hi Experts,

Need your help in this. 

We have a bar chart that shows the number of population increase every year. Is there a way, we can toggle between Population increase (in numbers) and percentage of Population increase (in percentage). Hoping for a slicer, from where End user can select whether he wants to view the population increase by number or percentage.

Based on user selection, Bar chart will show the outcome.

Thanks.

[Anonymous · Accepted solution]

Hi @Anonymous 

You can create a bookmark to switch between 2 identical graphs.

Place 2 graphs on top of each other and with bookmarks change between the views.

Here is a quick (and dirty) example:

[Anonymous]

HI @Anonymous 

Many thanks for your reply.

It should work for me. Can you please share this .pbix file with me.

Thanks and Regards

[Anonymous]

Hi @Anonymous 

Here you go.

Good Luck!
A

[Anonymous]

Hello,

Sorry to re-open an old post but I can't get it to work @Anonymous 

I duplicate the visual.

Select one > Add Bookmark (selected visual)

Select the other > Add Bookmark (selected visual)

Add a bookmark button where action is going to the right bookmark.

It's just that?

Thank you!

[Anonymous]

Hi @Anonymous 

Many thanks 🙂