Sorting Measure instead of columns | liveConnection | custom ranking

[ElectroHH]

Hi Community,

I currently face a new problem and need your help. Most of the time I work with the import method for Power BI Reports, but this time I have a LiveConnection and face new issues as I am not allowed as a Admin on the database (data warehouse) and cannot work / sort the columns and need a measure.

The situation is followed:

I want to custom sort a chart but don't know how without making 1) a mapping table in the back. 2) I also cannot sort the underlying column as it is on the DWH. 

Solution number 3 would be a measure which says:

column value "not valid" is 1, "low" is 2, "medium" is 3, "high" is 4, "very high" is 5 or something like this... because then I can use this measure to show on the graph and sort it ascending / descending. 🙂

Could you provide some tips or maybe a measure which does that?

This would help very much!

Thanks in advance, Electrohh

[v-jianboli-msft · Accepted solution]

Hi @ElectroHH ,

Please try:

Measure =
SWITCH (
    SELECTEDVALUE ( Sampledata[Type] ),
    "not valid", 1,
    "low", 2,
    "medium", 3,
    "high", 4,
    "very high", 5
)

Then apply the measure to the visual's tooltips:

Sort by measure:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.