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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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 

[amitchandak]

@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

[Anonymous]

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