Forum Discussion
Solved
Dynamic title based on two slicers
Hi, I've managed to build a dynamic title based on 1 slicer. I'd like to change the code in order to include same rules with second slicer. S1 = "PR % Impact by TOP10 Losses on "
&
IF(
NOT(...
Hi hejszyszky , you could consider the following:
Slicer Selections =
VAR _Name = ISFILTERED ( 'Summarized Raport'[Name] )
VAR _Area = ISFILTERED ( 'Summarized Raport'[Area] )
RETURN
"PR % Impact by TOP10 Losses on " &
SWITCH( TRUE() ,
AND ( _Name , NOT ( _Area ) ) , "selected Names: " & CONCATENATEX ( VALUES ('Summarized Raport'[Name] ) , 'Summarized Raport'[Name] , "," ) ,
AND ( _Area , NOT ( _Name ) ) , "selected Areas: " & CONCATENATEX ( VALUES ('Summarized Raport'[Area] ) , 'Summarized Raport'[Area] , "," ) ,
AND ( _Area = TRUE , _Name = TRUE ) ) , "All selected Names and Areas" ,
"Plant"
)
Hi hejszyszky , you could consider the following:
Slicer Selections =
VAR _Name = ISFILTERED ( 'Summarized Raport'[Name] )
VAR _Area = ISFILTERED ( 'Summarized Raport'[Area] )
RETURN
"PR % Impact by TOP10 Losses on " &
SWITCH( TRUE() ,
AND ( _Name , NOT ( _Area ) ) , "selected Names: " & CONCATENATEX ( VALUES ('Summarized Raport'[Name] ) , 'Summarized Raport'[Name] , "," ) ,
AND ( _Area , NOT ( _Name ) ) , "selected Areas: " & CONCATENATEX ( VALUES ('Summarized Raport'[Area] ) , 'Summarized Raport'[Area] , "," ) ,
AND ( _Area = TRUE , _Name = TRUE ) ) , "All selected Names and Areas" ,
"Plant"
)
Hmm, got unexpected expression NOT error
hejszyszky - sorry, I have update to include AND function to allow the NOT work.