Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
Tim-1967
New Member

Hierarchy slicer: Not to show field name in made selection

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

8 REPLIES 8
MihaiH
Frequent Visitor

Has anyone found a solution for this?

Amber_Dogra
Advocate I
Advocate I

Hi @Tim-1967 , @Domenick 
did you find any solution how to ged rid of field names(column names) to not get displayed in the selected space in the slicer.
Pls let me know if you have any kind of fix on this. Thanks

Anonymous
Not applicable

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 

v-zhenbw-msft
Community Support
Community Support

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.

hie1.jpg

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

hie2.jpg

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

hie3.jpg

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.

amitchandak
Super User
Super User

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


Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

powerbi_today.png

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?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.