March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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!
Solved! Go to 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", "" )
Best Regards
Hi @selimovd ,
Thank you for your reply.
Here is what I have tried-
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", "" )
Best Regards
Thank you @v-yiruan-msft !
This is very helpful!
Thank you for taking time and sharing attached file to make it easy to understand!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
92 | |
86 | |
77 | |
49 |
User | Count |
---|---|
166 | |
149 | |
99 | |
73 | |
57 |