Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 the...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    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!

     

parry2k's avatar
parry2k
Super User
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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())