Distinct sorting in slicers with concatenated measure

[Rednut]

Hi

I've set up a slicer that shows available options across multiple columns as below. This works as intended except that it is sorted alphabetically. I've looked up how to set up a separate table that orders each option and then merge the columns but it will only let me select 1 column to merge with. Due to the layout of my table(with a column listed for each option) i am unable to use this method to be able to sort the options how i'd like them.

Project Location Slicer = DISTINCT(

Union (

SELECTCOLUMNS ('Dashboard Data (2)',

"Project Location", 'Dashboard Data (2)'[Project Location (ROM)],

"Concatenate", 'Dashboard Data (2)'[Project Location]),

SELECTCOLUMNS('Dashboard Data (2)',

"Project Location", 'Dashboard Data (2)'[Project Location 2 (GS)],

"Concatenate", 'Dashboard Data (2)'[Project Location]),

SELECTCOLUMNS('Dashboard Data (2)',

"Project Location", 'Dashboard Data (2)'[Project Location 3 (Other)],

"Concatenate", 'Dashboard Data (2)'[Project Location]

)))

The slicer always shows GS / Other / ROM in that order

I would like to order them as ROM - 1 / GS - 2 / Other - 3

Is this possible with the way my data is layed out?

Thanks.

[Anonymous]

Hi @Rednut,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Chew_WenJie · Accepted solution]

Hello, you may create a new column which 
SWITCH(TRUE(),
'Project Location'= ROM, 1,
'Project Location'= GS, 2,
'Project Location'= Other, 3)

after created the column, you may select the [Project Location] column and sort by column you just created.

Hope this can helps you.