March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello,
I have in my dashboard a slicer awith two levels country and city.
When I select Paris inside France, in Desktop the slicer gets "Multiple Selection" text but when I publish the dashboard the slicer gets "France (country) + Paris (city)".
I would like to see it like this "France + Paris", without name fields in parenthesis.
Is it possible?
Thanks
Has anyone found a solution for this?
Hi @Tim-1967 ,
we running into the same problem as you Tim. Do you find a workaround for your problem?
@amitchandak : Do you have any idea how we change change the displayed values in the slicer?
I know we can display them in the titel or header but maybe there is an idea to change the selected slicer values to only values and not attribute name in brackets.
Best
Manuel
Hello @Tim-1967 ,
We're sorry that you can only control the title of another Visual with a slicer, you can't use Slicer to control your own title.
Slicer 1 only controls the title of the table visual.
You can create a measure like this and put it in the title text.
Measure =
var _x = SELECTEDVALUE('Table'[name1])
var _y = SELECTEDVALUE('Table'[name2])
return
_x & "+" &_y
If you want to control the title of slicer 1, you must create a new table that contains the hierarchy slicer, and then use it to create a new slicer.
Next, create a new measure to control slicer 1.
Measure 2 =
var _x = SELECTEDVALUE('Table 2'[name1])
var _y = SELECTEDVALUE('Table 2'[name2])
return
_x & "+" &_y
If you don't meet your requirements, could you show the exact expected result based on the table you shared?
Best regards
Community support team _ zhenbw
If this post helps,then consider Accepting it as the solution to help other members find it faster.
BTW, pbix as an attachment.
@Tim-1967 , The information you have provided is not making the problem clear to me. Can you please explain with an example.
where you are getting that, can you share some screenshot
Appreciate your Kudos.
Hi @amitchandak,
Point 1 is how I see slicer in desktop
Point 2 is how I see the slicer in the published report (online)
Point 3 is how I'd like to see the slicer in the published report
Hope it helps
Thanks
Did you ever find a solution?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
87 | |
87 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |