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.
I have a matrix and I want the Row item (called Product) to be sorted in a specific order so I created a column in Query Editor called 'Order' and i've used an IF statement to define the order as 01, 02, 03 etc.
I've then sorted Product by the Order column in the Modelling tab, and it's made no difference to the order whatsoever!
I tried changing the column type of 'Order' from decimal to text, to whole number and none of these are working.
What's the secret???
Hi,
I came across the same issue. I went to edit query, I have a simple column called code_person. Selected said column as 'whole number'.
It works fine when I sort them in power query. When I go back to the Data View, they are showing up like this:
any ideas why?
thanks!
ok, so I just discovered that you have to change the Data Type to whole number, in order for it to get ordered as a number.
So I wonder, what's the point in selecting the type of data in editing query, if I have to do it again in Data View?
@Anonymous
Make sure that the format of the field is of data type: Whole Number and not Text or anything else.
When you say you cant see the ordering... do you mean that you created a table object or chart and the ordering is not working?
Or you just want to see the ordering on the background data?
Also have you used the sort by column on Modelling tab?
Yep i've used whole number, and I created a matrix and the ordering is not working.
Yes I used the sort by column on the modelling tab.
When I applied the sort by, it did not affect the order in the matrix. It's like it's not recognising the Order column, but it's not erroring.
@Anonymous
Can you share the workbook with us so as to have a look at it?
I've attached some screenshots of the relevant areas, I can't attach the worksheet due to the data it contains.
Hi @Anonymous,
Based on my research, you could refer to below link to custom sort your column:
https://community.powerbi.com/t5/Desktop/Custom-Sorting-in-PowerBI/td-p/126534
Regards,
Daniel He
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |