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

Don'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.

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.


Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.