Forum Discussion
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
- lbendlin
Super User
Set Show summary to "off" and then write your own DAX formula for the Title text.