Display of selected value in slicer with multiple data elements

[LucMarv]

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....

[lbendlin]

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

[LucMarv]

I dont seem to have that option...

[LucMarv]

Would this be a version thing? 

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

[lbendlin · Accepted solution]

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

[LucMarv]

Thank you! You have answered my question and I'll accept this as the solution. 

I have three levels, so will have to think about how to adjust this two level version to a three level version!

[LucMarv]

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

Regards,
LUc