Filter Selections in Card Sorted by Specific Order

[Anonymous]

Hi,

I'm trying to create a Card visual that will show all the slicer selections the end user has selected - but the selections are not showing in the order each column has been sorted by.  Is there a way to sort what is being displayed by the same order the slicer column is sorted by?

Example:

I have the following in my data (COUNTRY is "Sort Column by" COUNTRY_INDEX and REVENUE is "Sort Column by" REVENUE_INDEX):

COUNTRY      COUNTRY_INDEX       REVENUE          REVENUE_INDEX
USA                1                                 <$25K               1

Canada           2                                 $25-50K            2

Mexico           3                                  $50K+              3

When the user selects the slicer I want it to show in a card like this:

Country: Canada, Mexico 
Revenue: <$25K, $25-50K

But I can't seem to get it to show in the order I want above - it will alphabetize the order like this:

Country: Canada, Mexico 
Revenue: $25-50K, <$25K

This is my measure I'm using (I'm just showing the first 2 slicers but I have many more):

IF(ISFILTERED(TABLE[COUNTRY]),CONCATENATE("COUNTRY: ",
CONCATENATEX(VALUES(TABLE[COUNTRY]),TABLE[COUNTRY],", ",TABLE[COUNTRY])),BLANK()) & UNICHAR(10) &
IF(ISFILTERED(TABLE[REVENUE]),CONCATENATE("REVENUE: ",
CONCATENATEX(VALUES(TABLE[REVENUE]),TABLE[REVENUE],", ",TABLE[REVENUE])),BLANK())

Thanks!

[parry2k · Accepted solution]

@Anonymous try this:

CONCATENATEX(SUMMARIZE ( TABLE, TABLE[REVENUE], TABLE[REVENUE_INDEX]),[REVENUE],", ",[REVENUE_INDEX])),BLANK())

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

THANK YOU SO MUCH!!

This worked perfectly

[parry2k]

@Anonymous give sort order in concatenatex function , for example

CONCATENATEX(SUMMARIZE ( TABLE, TABLE[REVENUE], TABLE[Revenue Sort Key]),TABLE[REVENUE],", ",TABLE[REVENUE Sort Key])),BLANK())

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

Hi parry2k

Thank you for your response!

I replaced "Revenue sort key" with Revenue_Index but it can't find the column in my table?  Am I using it incorrectly?

CONCATENATEX(SUMMARIZE ( TABLE, TABLE[REVENUE], TABLE[REVENUE_INDEX]),TABLE[REVENUE],", ",TABLE[REVENUE_INDEX])),BLANK())