Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
HI,
I have a slicer and want to order it in a custom way (not necessarily alphabetical). As a result i have followed multiple methods to try and achieve this.
One of them is described here:
Solved: Sort Slicer Values - Microsoft Power BI Community
Where i have made another column called 'rank', given it a number (1,2,3,4 based on the order i want), and then i get to the last step where it says i select 'sort column.' This last step does not work for one of the two slicers i tried this on.
How else can i go about this??
Solved: Sort Slicer Values - Microsoft Power BI Community
this is the step that does not work for me...
Solved! Go to Solution.
Hi @kkjoy81 ,
Go to Data Model ->Click on category ->Click on Sort By Column -> Select Rank
The change would automatically reflect in your slicer values.
PFA .pbix for reference.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
Hi @kkjoy81 ,
Go to Data Model ->Click on category ->Click on Sort By Column -> Select Rank
The change would automatically reflect in your slicer values.
PFA .pbix for reference.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 46 | |
| 43 | |
| 39 | |
| 19 | |
| 15 |
| User | Count |
|---|---|
| 68 | |
| 67 | |
| 31 | |
| 27 | |
| 24 |