Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am trying to to change the text "Multiple selections" when mutiple values of a slicer are selected. I want to change it to custom text. In my example, my slicer selects a "Project City" and calculates all my values, however I want to combine the values for 2 "Project Cities" and have it renamed as "Project City 1 + Project City 2" rather than "multiple selections". I am fairly new to Power BI also.
This is how it shows in my dashboard when I select multiple Cities:
Solved! Go to Solution.
Hey @Daniel_DA
Unforunately you wont be able to change the multiple selections part of the slicer.
However good new!
You can display this using a measure. For example I have brand names on my slicer and it appear like this:
Here is the measure I have used to do this which I have added to a card visual and placed below my slicer:
Slicers selected = CONCATENATEX ( VALUES ( 'Product'[BrandName] ), 'Product'[BrandName], ", ")
Appreciate your Kudos!
Please accept the solution if it answers your question 🙂
Hey @Daniel_DA
Unforunately you wont be able to change the multiple selections part of the slicer.
However good new!
You can display this using a measure. For example I have brand names on my slicer and it appear like this:
Here is the measure I have used to do this which I have added to a card visual and placed below my slicer:
Slicers selected = CONCATENATEX ( VALUES ( 'Product'[BrandName] ), 'Product'[BrandName], ", ")
Appreciate your Kudos!
Please accept the solution if it answers your question 🙂
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |