Odtnhj

How can I sort by columns in Matrix in Power BI.

Let me explain a bit. I have this table (sample).

There is Unit and Rating (New Units will be always added often).

I try to show the data in Matrix in Power BI and I got this but I can't sort by High, Medium or Low at all.

I want to sort in this order (High Desc, Medium Desc and Low Dec) order.

How can I achieve it? I am quite new to Power BI.

The trick is to create an order column and use that sort on with the Sort by Column feature.

The problem though is if you write a calculated column like this:

Order = SWITCH(Table1[Rate], "High", 1, "Medium", 2, "Low", 3)

and then try to sort on that, then you'll get a circular dependency error basically saying you can't sort by a column that is dependent on the column you are trying to sort.

There are a couple of workarounds.

One possibility is to create your order column in the query editor, which should be a simple custom column:

if [Rate] = "High" then 1
else if [Rate] = "Medium" then 2
else if [Rate] = "Low" then 3
else 0

Use this column to sort by.

Another possibility is to define a new table that with your ordering preference.

Enter Data:

Rate Order
-------------
High 1
Low 3
Medium 2

Call this table Sort and create a relationship with the original table on the Rate column.

Now create a calculated column on the original table that pulls over the Order value.

Order = RELATED(Sort[Order])

Use this column to sort by.