Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Buttons

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, ...
  • v-xuding-msft's avatar
    6 years ago

    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.