Dynamic Buttons

[Anonymous]

I am working on a multi=page report, with only a single page visible, and all the other pages hidden.

The primary page is the Sales Summary, and the other pages are North America, South America, EMEA and Other.

For my current solution, I have four different cards, each cards shows the number for each region, the cards have a border, to look like a button. Then I added invisible buttons (made the background white with no border and no text, and the action is bookmark to go to the individual page). The buttons go on top of the individual cards.

I have a couple of issues wiht this solution:

1. It seems pretty clunky. Is there a way for me to have a single "button" that can display the number and act as a button that I can click on to go the specific bookmarked page?

2. Is there a way to make these buttons appear dynamically, so when a partocular region has no sales, the button will not show?

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

1. It seems pretty clunky. Is there a way for me to have a single "button" that can display the number and act as a button that I can click on to go the specific bookmarked page?

Yes. You could show the fixed button text or dynamical one using functions and choose bookmark type in Action.

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

2. Is there a way to make these buttons appear dynamically, so when a partocular region has no sales, the button will not show?

If you mean show the buttons dynamically in bookmarks, you just don't put one which page don't contains sales of the region. If I misunderstand, you could use the selection pane to make them show or hide.

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

You could watch the gif. to have a try. It does't match your requirement fully. But you could get a few ideas how to use the selection pane. Hope it can help you.

[amitchandak]

@Anonymous , Seem like hiding bookmark is not an option. There is already an idea for that. Vote for that

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33726934-hide-certain-bookmarks

refer :

https://www.youtube.com/watch?v=5TaZQFc-t58

or Refer to these solutions if these can help

https://www.youtube.com/watch?v=PTOJC42rg_k

https://www.youtube.com/watch?v=z9jdkyyE3WU

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=024bfbef-72e7-48a7-9be5-92dba49a4091&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer