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.
Is there a way to set the order for a group? I'd like to change the order to:
Gross Margin
Expenses
Amortization
Interest
Taxes
Solved! Go to Solution.
Generally, you need to go into your query and create a "sort" column which essentially is a column that looks at your other column and returns the integer sorting that you want. So, basically a conditional column that is "if [column] = Gross Margin then 1, else if [column]=Expenses then 2..."
Then you can set your "Sort By" column in Desktop for the original column to be this "sort" column.
If you want the obvious fix vote for https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16895230-ability-to-specify-custo...
Generally, you need to go into your query and create a "sort" column which essentially is a column that looks at your other column and returns the integer sorting that you want. So, basically a conditional column that is "if [column] = Gross Margin then 1, else if [column]=Expenses then 2..."
Then you can set your "Sort By" column in Desktop for the original column to be this "sort" column.
The order is usually alphabetically.
You can add a prefix to the name to order it in the order you like
1. Gross Margin
2. Expenses
3. Amortization
4. Interest
5. Taxes
After messing around with DAX and trying to create a sort index, but running into circular dependency errors, I decided to use this method instead. Simple and effective; only adds 3 extra characters, which I can live with. Thanks for the tip!
But if you have more than then items the first is set wuth the eleven 😞
For tens of items, prefix each item with a two-digit number: 01, 02, 03, . . . , 10, 11, 12, . . .
But if you have more than then items the first is set wuth the eleven 😞
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |