Forum Discussion

BIanon's avatar
BIanon
Helper V
2 years ago
Solved

Hierarchy slicer long text strings

I have a slicer containing a hierarchy made up of multiple long text strings. When the user selectes a low level, the slicer looks ugly as it is trying to display all levels at once.
Is there a way I can make my slicer only display the lowest selected level ?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi BIanon

    You can refer to the following solutions

    1.Create a separate slicer for each level, as shown in the following picture

    2.Use the field paramater

    (1) Create the field paramater

    (2) Then create a new slicer, and put the paramater to the field, and set' show values of selected field'

    Output

     

     

    You can refer to the following link about the field paramater

    https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters#create-a-field-parameter

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

  • Power66's avatar
    Power66
    Regular Visitor

    Did you ever find a solution for this?  I am facing the same issue but don't want to create seperate slicer for each level as suggusted as that would make the visual very busy.