Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
Really hope someone can help!
I have two slicers that corresponds to two different columns in the same table.
I want to do custom sorting on both slicers, however i cannot seem to make this work.
The table looks something like this:
Key | Column1 | Column2 |
123 | 2 | 5 |
124 | 2 | 10 |
125 | 2 | Free |
126 | 5 | 5 |
127 | 5 | 10 |
128 | 5 | Free |
129 | 12 | 5 |
130 | 12 | 10 |
131 | 12 | Free |
132 | Free | 5 |
133 | Free | 10 |
134 | Free | Free |
I have tried creating a new table with the distinct values for column1 and the sort order, and then used the function "sort by column", which works for column1. However, I cannot seem to do this for the second column as well - in this case it tells me that the table is already sorted. Can anyone help?
Hi @trine_norris ,
Create 2 tables with index no and link it though the relationship.
Sort both these tables "sort by column" by index.
Regards,
Harsh Nathani
Hi @trine_norris ,
Did the solution work for you.
Please mark as solution for other community members to benefit.
Regards,
Harsh Nathani
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |