Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Gyan
Frequent Visitor

Customizing Slicer "select all" option in power BI

Hi there,

 

Problem statement:

I have a situation in report designing where I have a couple of slicers in the report and as per the Client, he doesn’t want to see the title or label of the Slicers.
Now if there is only a single value selected in the slicer then obviously it displays that value but in case of "multi-select" or in case of "select All" user don’t see any value.
Now assume there are 5 slicers without a label or title and all saying "All" it’s a mess for end-user.

 

Expectation:

Now I'm looking for a workaround where I can customize the "Select All" option to say something else like "All categories", or "All countries"

 

Thank you for looking into it!

 

 

1 ACCEPTED SOLUTION

Hi @Gyan ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a measure as below to get the customized label and apply this measure on the card visual.

Customized label =
VAR _selcount =
    COUNTROWS ( ALLSELECTED ( 'Countries'[Countries] ) )
VAR _allcount =
    CALCULATE (
        DISTINCTCOUNT ( 'Countries'[Countries] ),
        ALL ( 'Countries'[Countries] )
    )
RETURN
    IF ( _selcount = _allcount, "All countries", "" )

yingyinr_0-1646810623425.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Gyan
Frequent Visitor

Hi @selimovd ,

 

Thank you for your reply.

 

Here is what I have tried-

  1. I have created a label for slicer using a card (let’s say "All counties"),
  2. I have created one measure which is returning the selected value ( 0 in case single select, 1 in case multi or all)
  3. Now I was trying to use the selected value measure as a filter for card visual so that I could display the value when the selected value returns 1, but somehow this filter is not getting enabled it is not letting me enter 0 or 1 value in case of advanced filtering.

 

I have already tried this approch to display or hide any visual but not sure why it is not working in this case.

Are you suggesting to go by the same approach  I have tried above or is there any other workaround? 

 

Hi @Gyan ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a measure as below to get the customized label and apply this measure on the card visual.

Customized label =
VAR _selcount =
    COUNTROWS ( ALLSELECTED ( 'Countries'[Countries] ) )
VAR _allcount =
    CALCULATE (
        DISTINCTCOUNT ( 'Countries'[Countries] ),
        ALL ( 'Countries'[Countries] )
    )
RETURN
    IF ( _selcount = _allcount, "All countries", "" )

yingyinr_0-1646810623425.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you @v-yiruan-msft !

 

This is very helpful!

 

Thank you for taking time and sharing attached file to make it easy to understand!

selimovd
Super User
Super User

Hey @Gyan ,

 

you could put a label above the slicer that is only visible when "All" ist selected. This label could in this case show "Countries". When there is a selection of a country, then the label would disappear.

 

Would that be an option?

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.