sort matrix visual using custom buttons outside visual

[siva_powerbi]

Hello Experts

I have a matrix visual where I am displaying product names, only sorting option I got is to click on the product name in column header that will sort either ascending/descending.

I have a requirement where I need to have 2 button above matrix visual and click on one button should sort ascending and other should sort the visual descending.

Unfortunately I couldn't find any way to do this where sorting of a visual is triggered by the other component outside the visual.

Any help is appretiated.

Thanks

[Pragati11]

Hi @siva_powerbi ,

When you say sorting the matrix visual - does it mean you need 2 sorting buttons outside the matrix visual to sort the matrix visual by product Name in ascending/descending order?

You can achieve this by using bookmarks and buttons in Power BI.

But I am still struggling to understand that if there is already a sort icon against product Name column in matrix visual, why you require extrernal sort buttons.

Thanks,

Pragati

[siva_powerbi]

Hi Pragati

Thanks for the reply.

Can you please help to elaborate more on using bookmarks for sorting as if filter is applied on the visual still bookmarks work?

Yes, their is a sort icon on visual but we can't see both ascending and descending at once, Also my organization need to have a sort buttons in differet shatpes and different background to enhance user experience.

Thanks

Siva

[Pragati11 · Accepted solution]

Hi @siva_powerbi ,

You need to make sure that the DATA option is enabled when using filters on the report page along with the bookmarks.

Thanks,

Pragati

[siva_powerbi]

Thanks for the solution.. its working

Only change here is uncheck All Visuals and check Selected Visual

[VahidDM]

Hi @siva_powerbi 

AS @Pragati11 mentioned you can achive this with bookmark.

Watch these 2 video to learn how to set and use Bookmark in Power BI:

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

https://youtube.com/watch?v=_Afcj8mT5_Q

and see this link:

Create report bookmarks in Power BI to share insights and build stories

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

Appreciate your Kudos  !!