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

  • 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's avatar
      Anonymous
      Not applicable

      THANK YOU SO MUCH!!

       

      This worked perfectly

  • 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

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