Perhaps something like =match(only({1}YourDimensionHere),'Value1','Value2', ...etc, 'Value10'). The list 'Value1','Value2', ...etc, 'Value10' should be in the order you want to sort them.
Perhaps something like =match(only({1}YourDimensionHere),'Value1','Value2', ...etc, 'Value10'). The list 'Value1','Value2', ...etc, 'Value10' should be in the order you want to sort them.
Found this really helpful, I am working on School Exam grades, so sorting the grades in A*, A, B, C, D, E, F, G, U was helpful.
I f implimented this at a subject level, i.e. English, Maths, Biology, Physics, Chemistry.....but the bar graph has a drill down, i.e. I select English and I can drill down to the classes in English, the expression sort order does not go to that drill down, but I am sure I can make it.
