topic Re: display "All" when all filter is selected on a slicer in DAX Commands and Tips

display "All" when all filter is selected on a slicer

Anonymous — Wed, 07 Dec 2022 10:32:48 GMT

Hello,

On a title of a visulization, i've displayed the text when a the slicer is selected with this measure :

TitleTxt = VAR Region = CONCATENATEX( VALUES('Dimension - Région'), 'Dimension - Région'[REGION], ", ") VAR Levier = CONCATENATEX( VALUES('Dimension - Levier'[LEVIERS]), 'Dimension - Levier'[LEVIERS], ", ") VAR Agence = CONCATENATEX( VALUES('Dimension - Agence'[AGENCE]), 'Dimension - Agence'[AGENCE], ", ") RETURN "Budget : " & Region & " - " & Levier & " - " & Agence

It's working well but for all slicer i have a lot of filter so the vizualisation is flooded with text.

What i wanna do is when all filter is selected for each slicer it dosen't display all the text but instead "ALL"

Example : All region is selected so instead of showing all region it shows "ALL"
Same for LEVIER and AGENCE

So in the end it could : Paris - ALL - ALL

If it's not clear i'm sorry for my english

Re: display "All" when all filter is selected on a slicer

amitchandak — Wed, 07 Dec 2022 14:42:24 GMT

Anonymous , you can use isfiltered

example

VAR Levier = if(isfiltered('Dimension - Levier'[LEVIERS]) , CONCATENATEX(
VALUES('Dimension - Levier'[LEVIERS]), 'Dimension - Levier'[LEVIERS], ", "), "All")

HasOneValue , Isfiltered: https://www.youtube.com/watch?v=hXg3kRFSGjA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=38

Re: display "All" when all filter is selected on a slicer

Anonymous — Wed, 07 Dec 2022 15:27:48 GMT

Ty for your answer but your code is not working properly. When all the filter from the slicer is displayed, i still have all the filter showed in my vizualisation

TitleTxt =

VAR Levier = if(isfiltered('Dimension - Levier'[LEVIERS]) , CONCATENATEX(

VALUES('Dimension - Levier'[LEVIERS]), 'Dimension - Levier'[LEVIERS], ", "), "All")

RETURN

"Budget : " & Levier

Re: display "All" when all filter is selected on a slicer

Anonymous — Thu, 08 Dec 2022 02:16:10 GMT

Hi Anonymous

Based on your formula alone, it doesn't give the right advice. Perhaps you can provide a simple sample so that we can give you a suitable recommendation based on your data and needs.

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

Re: display "All" when all filter is selected on a slicer

Anonymous — Thu, 08 Dec 2022 09:09:18 GMT

Hi,

Yes sure.

When only one item is selected it looks fine

But when more than 3 thing is selected it start to get ugly

Ideally, i want to display a text when the user select more than 3 filter on each slicer