The sorting and filtering applied to stacked bar charts are not being retained or saved.

[Prarav]

Hello,

I have a dashboard with 10 visuals. I've grouped six visuals together and displayed them as tabs. Four out of six visuals are being created as a stacked bar chart. When I click on Visual A, the rest of the visuals hide due to bookmarks being created. I have requirement to update this dashboard to sort the stacked bar chart visual so that the count values are displayed from highest to lowest. Now my issue is: when I sort visuals B, C, and D from highest to lowest count values, then sort Visual A, the sorting changes are not saved for B, C, and D. How to sort the visual from highest to lowest and ensure that the sorting changes are saved and published effectively?

Another issue : when I attempt to remove the country "Italy" from the slicer and three stacked bar charts within the same dashboard. Despite applying the filter to and removed ‘Italy’ from one visual, it fails to save the filters on another visual. How to make this work?

[Prarav]

Thank you so much for the help, it works now. 

[Anonymous · Accepted solution]

Hi @Prarav ,

For your first question:

Bookmarks save the current filters and slicers, cross-highlighted visuals, sort order, and so on.

For each visual (B, C, and D), manually sort from high to low count value.

To do this, select the ellipsis (...) on the visual, select Sort by, and then select the measure in descending order.

After each visual is sorted, the bookmarks associated with those visuals need to be updated.

Go to the View tab, select Bookmarks Pane, find the bookmark related to the visual, and click Update.

For more information about bookmarks, please see:

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

For your second question:

go to the Filters pane, check if "Italy" is in the list and delete it if it is.

With the slicer selected, go to the Format tab, select Edit interactions, and ensure that the filter icon is activated for the visuals you want to be affected by this slicer. 

For more details on slicers and their interactions, you might find this guide useful: 

Slicers in Power BI - Power BI | Microsoft Learn

I would be grateful if you could provide me with pbix file for testing, please upload the pbix file on Power BI Desktop without logging in to your own account.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!