Forum Discussion

hejszyszky's avatar
hejszyszky
Helper II
4 years ago
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(...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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"
       )

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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"
   )