How to display the TOP 10 amount details, supplemented by “Next 10” and “Prev 10” buttons?

Question

I wanted to display the top 10 values in a matrix and add a button supplemented by "Next 10" values which again navigates to previous 10 values page. Can someone help me here how this works in power BI?

Answer 1

Hello,

To display the top 10 values in a matrix with a next 10 navigation button in power BI, start by setting up a matrix visualization and applying a top n filter to show the top 10 values based on a specific measure. Then add a button to the report canvas for navigation purpose. configure the button to navigation to another report page displaying the next set of top values when clicked. test the mghpatientgateway functionality to ensure seamless navigation between different sets of top values in the matrix visualization.

Answer 2

Hi Banushree Am (CW),

Thanks for reaching out to us on the Microsoft Q&A forum.

Create a metric or table that displays the next 10 and previous 10 records. Include fields such as amount and supplement in the table. Utilize visual level filters, providing a 'Top N' option with the ability to select either top or bottom items based on your preference. Please see the attached screenshot for reference:

If you are still facing any issue, please let us know in the comments.

Please Accept Answer & Upvote so that it would be helpful to community members.