Use Slicer to Filter, Sort and Group the data in all report visuals

[aakif_aslam]

Hi there,

My client has a specific requirement, not sure if it is possible in Power BI.

As per the image shared, the client basically wants to have -

1. Slicer 1 to Filter the data in the report (Basic slicer functionality)
2. Slicer 2 to Group the data with selected Dimension ?
3. Slicer 3 to Sort the data in the report by selected dimension (default - Asc) ?

It'll be a great help if somebody can confirm the possibility to achieve this.

[aakif_aslam]

Hi @amitchandak, thank you for the help it works.

For sorting, bookmarks is a good option but for limited number of measures. 

[amitchandak · Accepted solution]

@aakif_aslam , For Group by you, can use field parameters

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE

For sort, I doubt slicer can do, you have to check if bookmark and buttons can help

Bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

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