Sorting a matrix column containing strings and percentages

[mh_vasconcelos]

Hi guys!

I needed to sort from largest to smallest, but always placing the strings last (the field with the "Inconsistent" warning), but the strings appear first in the ranking.

Is there any way to display the matrix to place the percentages first, and the "Inconsistent" warnings last?

Note: I know there is an alternative way to conditionally format the inconsistent values ​​with the color red, and leave them blank, for example, providing a caption explaining that the red color means "Inconsistent". However, I would like it to be possible to place the name "Inconsistent" in this column in the last positions, when we sort from largest to smallest.

Thank you in advance

[speedramps · Accepted solution]

Create a another column

If the value "Inconsistent" then set it to a high maximum value

else set it to the column value

Then go into the data model and change the "sort by" for your colum by the new column.

Learn how here https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

We are unpaid volunteers and you have got free expert help which took a lot of effort.
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos.
If you need to change or extend your request then please raise a new ticket.
One question per ticket please !
You will get a quicker response and each volunteer solver will get the kudos they deserve.

If you quote @speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

However I decline to help impolite lazy members twice who ask misleading or incomplete questions and then dont accept the correct soltion.

Please now click the [accept as solution] and the thumbs up button. Thank you