Forum Discussion

LucMarv's avatar
LucMarv
Icon for Helper I rankHelper I
4 years ago
Solved

Display of selected value in slicer with multiple data elements

Hi have a slicer which includes the columns from the following table:

 

The slicer looks like:

 

 

When I select the highest level, the display of the selected value makes sense:

 

 

When I select a element from the 2nd level, I get the following:

 

I dont really like the 'Bowel + Colon', as clearly colon is a subcategory within Bowel.

However, the main issue I have (which I hope someone knows how to solve) is how to get rid of the column names (Grouping_LvL1, Grouping_LvL2).

 

Currently showing --> 'Bowel (Grouping_LvL1) + Colon (Grouping_LvL2)'.

Better                    --> 'Bowel + Colon' 

Even better           --> 'Colon'

Best                       --> 'Colon (within Bowel)'

 

I hope you have suggestions! I was not able to find anything....

 

 

 

 

 

  • yes, but you can do this with your version too - the title text has the fx icon next to it.

     

    Here's my DAX:  (calculated column)

    Column = 'Table'[Rnk] & " (within " & 'Table'[host] & ")"

6 Replies

  • Set Show summary to "off"  and then write your own DAX formula for the Title text.

     

     

    • LucMarv's avatar
      LucMarv
      Icon for Helper I rankHelper I

      That is AWESOME! Could you add your DAX for completion?

      Regards,
      LUc

      • LucMarv's avatar
        LucMarv
        Icon for Helper I rankHelper I

        Would this be a version thing? 

        I am running Version: 2.96.1061.0 64-bit (August 2021)