Display only selected hierarchy name in the slicer visual

[Optimusprime_25]

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

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.

[MohammadLoran25 · Accepted solution]

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

[Optimusprime_25]

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