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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Optimusprime_25
Resolver I
Resolver I

Display only selected hierarchy name in the slicer visual

Hi Team,

 

Currently we are implementing Hierarchy in the Slicers in Power BI reports. We aee facing an issue wherein we couldn't able to resolve the issue. When some value is selected in the slicer, then it is displaying the complete path from Top level hierarchy to the selected value.

 

You can see in below snapshot, when Group Sales is selected then we are able to see the text as Sales (KPIS) + GrouP Sales (KPI). Ideally it should be Group Sales

Optimusprime_25_0-1682683867768.png

Our requirement is to display only selected value in the slicer. (Ex: Group Sales)

 

Could you please look into this issue and provide the solution.

 

Thanks.

 

 

1 ACCEPTED SOLUTION
MohammadLoran25
Super User
Super User

Hi @Optimusprime_25 ,

As your slicer is Single-Select, So Create a measure as below:

SELECTEDVALUE('YourTable'[YourColumn])

Then put this measure in a card visual and make its size based on the slicer size and put it over the slicer. 

Then once you drop down and select a data, it would show your desired option.

 

It helped? Mark it as an accepted solution.

Regards,

Loran

View solution in original post

2 REPLIES 2
MohammadLoran25
Super User
Super User

Hi @Optimusprime_25 ,

As your slicer is Single-Select, So Create a measure as below:

SELECTEDVALUE('YourTable'[YourColumn])

Then put this measure in a card visual and make its size based on the slicer size and put it over the slicer. 

Then once you drop down and select a data, it would show your desired option.

 

It helped? Mark it as an accepted solution.

Regards,

Loran

@MohammadLoran25  Thanks for your prompt response.

 

We have created a measure as mentioned by you and followed the steps.

Now it is working fine for us.

 

Thank you.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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