Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |