Show value on Button click

[marial16]

Hallo experts!

i was trying to find out how buttons work in BI Desktop.

For example i have 2 buttons. When i select the Count button i want to see the second card (27) and when i select the Volume i want to display the first card with the Sum. I tried putting the cards on top of each other. I also tried to add bookmarks but still i cant figure out how that works.

i am using measures for both cards

Measure1 = Count(Sales[OpenQuant])

Measure2 = Sum(Sales[OpenQuant])

Any ideas on hot to achieve that?

Thank you

[Pragati11 · Accepted solution]

Hi @marial16 ,

Check this blog of mine where I have shown how one can hide/un-hide visuals based on selections on buttons.

https://datavibe.co.uk/f/toggle-between-charts-in-power-bi

I have considered bar charts, in your case it will be card visuals.

Thanks,

Pragati

[marial16]

it seems to work when i select from the Bookmarks pane but Not when i click the buttons..

[v-yanjiang-msft]

Hi @marial16 ,

You should first click the button, then in the Format button pane, turn on the Action option, change the Type to Bookmark, and select the corresponding bookmark you create for each button.

Then Ctrl+click the button to display result.

Best Regards,
Community Support Team _ kalyj

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

[marial16]

It was actually working with the right Ctrl key of the keyboard!

[Pragati11]

Hi @marial16 ,

You need to assign Bookmarks as an Action to the Buttons under format options for Buttons.

Thanks,

Pragati