Forum Discussion
Reordering values
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.
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-desktop
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍