Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a column in Power Query labelled 'priority'. There are 3 values: high, medium, low. When I create a table, I drag in the 'priority' column; however, it automatically orders them alphabetically = high, low, medium. Is there a way around this?
As they're not individual columns, I can't drag them into order. Sorting ascending/descending doesn't work either.
Thanks,
Solved! Go to Solution.
You should create a simple lookup table. On the Home tab, look for the button "Enter Data". Creat a table with three rows:
High 1
Medium 2
Low 3
After that, set the Sort Order column of the text field above to the INT field in that table. Lastly, join that table to the table that contains those values. Display the Text from this table instead. Power BI will then sort them by the INT in this lookup table.
Another method: Create a calculated column in your table with something like this:
Priority Sort = IF [Priority] = "High", 1, IF ( [Priority] = Medium, 2....)
And sort Priority by Priority Sort.
Proud to be a Super User! | |
Hi @AmyD
Presuming you want to order fom Low to High
In the table add a new column
DAX: NewColumn
Priority Sort = if('priority' = "Low" , 1,
if('priority' = "Medium" , 2,
if('priority' = "High" , 3,0)
Mquery: Add New Column
if([priority] = "Low" then 1 else
if([priority] = "Medium" then 2 else
if([priority] = "High" then 3 else 0
After you have implemented either one, go to the Data View and highlight the priority column and click on Sort by Column and choose the priority sort. The visual should then change
You should create a simple lookup table. On the Home tab, look for the button "Enter Data". Creat a table with three rows:
High 1
Medium 2
Low 3
After that, set the Sort Order column of the text field above to the INT field in that table. Lastly, join that table to the table that contains those values. Display the Text from this table instead. Power BI will then sort them by the INT in this lookup table.
Another method: Create a calculated column in your table with something like this:
Priority Sort = IF [Priority] = "High", 1, IF ( [Priority] = Medium, 2....)
And sort Priority by Priority Sort.
Proud to be a Super User! | |
Hello @AmyD ,
So first of all, Create a conditional column in Power query to identify if value equal to high then 1, medium then 2, low then 3.
the you load the data to Power BI, and sort the column of high meduim low by the one with numbers.
check this for more info https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |