Forum Discussion

Emma_'s avatar
Emma_
Helper II
11 months ago
Solved

Dynamic Title - Date Slicer (BETWEEN)

Hello, I would like to include a dynamic title for my date slicer. It is strange that it works perfectly when slicer is set as dropdown or list, but the issue appears when BETWEEN option is selected. I tested with slicer header text, title & subtitle text fields functions. Is this some sort of a bug? Do you have any workaround? Thank you.

 

This is my DAX:

TR Slicer Titel Datum =

SWITCH(SELECTEDVALUE(Translations[LanguageId]),
  "it",  "IT PLACEHOLDER",
  "fr",  "FR PLACEHOLDER",
  "de",  "DATUM",
  " ")
 

 

 

Need Help
  • danextian's avatar
    danextian
    11 months ago

    Hi Emma_ 

    Range slicers support dynamic headers. Ensure that there is a visual interaction between range slicer and other slicer types as the interaction is turned off by default.

     

     

     

5 Replies

  • MohamedFowzan1's avatar
    MohamedFowzan1
    Super User
    11 months ago

    Hi Emma_ 

     

    Could you try to have a textbox or card visual and have this as the title instead of doing this within the slicer.

  • Emma_'s avatar
    Emma_
    Helper II
    11 months ago

    yes, not the best option but if there is no other way I might do it like this.

    • MohamedFowzan1's avatar
      MohamedFowzan1
      Super User
      11 months ago

      Yes Emma_ this is a limitation or rather doesnt work as expected in the case of Between. I have noticed similar threads where they ended up using card visuals for header

  • danextian's avatar
    danextian
    Super User
    11 months ago

    Hi Emma_ 

    Range slicers support dynamic headers. Ensure that there is a visual interaction between range slicer and other slicer types as the interaction is turned off by default.

     

     

     

    • Emma_'s avatar
      Emma_
      Helper II
      11 months ago

      Hello danextian that was actually a great tip - it was the interaction between my date slicer and another slicer that was a problem. I fixed this now and all the dynamic titles work as expected. Thank you so much !