Forum Discussion

itskool's avatar
itskool
Advocate II
3 years ago

Dynamic slicer header/title

Hi All,

 

I was wondering if you could help:

 

I have a single-select slicer with a 3 level hierarchy.

I would like to show the lowest value level selected as a slicer header.

The standard "Show summary" functionality ends up showing all the levels of the hierarchy and this measure doesn't seem to work when used as a field value in the slicer header function (although it works when used in a card)

 

Product slicer header =
"Product (select P4 level): " & SELECTEDVALUE( DimProduct[Product Family (P4)]  )
 
Do you know if this is possible?
 
Kind regards,
Olga
Need Help

4 Replies

  • RMDNA's avatar
    RMDNA
    Solution Sage
    3 years ago

    Hi itskool - could you provide an example pic of the incorrect result when you do use the measure as a title?

    • itskool's avatar
      itskool
      Advocate II
      3 years ago

      Here it is: there is a selected valued after semicolon in the card visual but nothing in the header slicer when the same measure is added as a "function"

       

      • RMDNA's avatar
        RMDNA
        Solution Sage
        3 years ago

        Hi itskool - if you've assigned the measure as your title via conditional formatting, I don't see a reason why it wouldn't return the same value as in the card.

         

        Dumb question - does it appear when you make the slicer visual larger or the title font size smaller? There may not be enough space in the header to display the full value.