Custom Sort of the Priority Measure in a column

[Terry86]

I need to be able to sort a table by the Priority order that we actually use and not just the alphabetical sort. How can I do this?

[janis.plume]

Hi,

The workaround is to create a custom measures where you can assign a numeric value for each priority and then order the report by this custom formula.

I can create a formula like this:

CASE [Measures].[Issue priority]
WHEN "Highest" THEN 1
WHEN "High" THEN 2
WHEN "Medium" THEN 3
WHEN "Low" THEN 4
WHEN "Lowest" THEN 5
END

Now I can order the issue list accordingly:

I can remove this column and the order will persist:

Kindly,
Janis, eazyBI support