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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Frequent Visitor

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.


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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.