Top 10 Button on the report

Hi Dunner2020 ,

andre has the right idea, but you only need one chart, but two buttons.

1. Create two buttons, one with Top 10 text, one with All text.
2. Create a filter on your visual that shows an axis or column by TopN values, then use the measure for the value. For example, this is a small data set, so I used top 2.
   1. 

       

3. Hide the "top 10 button.
4. Create a bookmark and call this "Top 10" - it should be showing the All button, and the top 10 items. (change the text to have it say "Show All Items" if you want, or "Showing Top 10, click to Show All" - whatever is easiest for your users.
5. Now, remove the filter on the visual so all items are showing
6. hide the All button and show the Top 10 button
7. Create a new bookmark and call this All.
8. Assign the All bookmark to the All button, and the Top 10 bookmark to the Top 10 button.

See my PBIX file for an example. You will need to CTRL-CLICK the buttons in the desktop. In the service, just clicking works.