cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CC25
New Member

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!

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@CC25 try this:

 

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

 

Follow us on LinkedIn and YouTube.gif 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!

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

4 REPLIES 4
parry2k
Super User
Super User

@CC25 try this:

 

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

 

Follow us on LinkedIn and YouTube.gif 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!

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





THANK YOU SO MUCH!!

 

This worked perfectly

parry2k
Super User
Super User

@CC25 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 YouTube.gif 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!

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.