Forum Discussion
Filter Selections in Card Sorted by Specific Order
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!
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!
4 Replies
- parry2kSuper User
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!
- AnonymousNot applicable
THANK YOU SO MUCH!!
This worked perfectly
- parry2kSuper User
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!
- AnonymousNot applicable
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())