Forum Discussion

hejszyszky's avatar
hejszyszky
Icon for Helper II rankHelper 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(
        ISFILTERED(
            'Summarized Raport'[Name])),
            "Plant",
            IF(
                ISFILTERED('Summarized Raport'[Name]),
                CONCATENATEX(
                    values(
                        'Summarized Raport'[Name]),'Summarized Raport'[Name],",")
                        )
                        )

 

 

So - if i use slicer with Name there is only Name applied to title, but when i use slicer Area only area values are selected. There is no need to apply Area&Name in title. Just one of these.

Question is, how can i add to code above second slicer options?


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

     

     

     

     

     

     

5 Replies

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

     

     

     

     

     

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        hejszyszky  - sorry, I have update to include AND function to allow the NOT work.

    • hejszyszky's avatar
      hejszyszky
      Icon for Helper II rankHelper II
      4 years ago

      Hey! Works well, just had to edit. There is one paranthesis too much before 

      "All selected Names and Areas"

      Thanks a lot! 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    hejszyszky , Try like

     

    IF( ISFILTERED('Summarized Raport'[Name])
    CONCATENATEX(values( 'Summarized Raport'[Name]),'Summarized Raport'[Name],",") )
    &
    IF( ISFILTERED('Summarized Raport'[Plant])
    CONCATENATEX(values( 'Summarized Raport'[Plant]),'Summarized Raport'[Plant],",") )