Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
62 | |
59 | |
56 |