Forum Discussion

vr_2020's avatar
vr_2020
Frequent Visitor
5 years ago
Solved

Hierarchy Slicer

  I have a scenario where the data in a Table is available in column wise as follows: Continents Countries Cities ASIA INDIA CHENNAI ASIA INDIA MUMBAI ASIA I...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, vr_2020 

     

    Try like this:

    Measure = 
SWITCH (
    TRUE (),
    ISFILTERED ( 'Table'[Column3] ), MAX ( 'Table'[Column3] ),
    ISFILTERED ( 'Table'[Column2] ),
    MAX ( 'Table'[Column2] ), 
    ISFILTERED ( 'Table'[Column1] ), MAX ( 'Table'[Column1] ),
    " "
)

     

    Best Regards

    Janey Guo

     

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

     

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, vr_2020 

 

I checked it, and what you said should be a design and cannot be changed. If you don’t mind, you can create a measure and put it in the card visual and put the card visusl on top of the slicer.

Like this:

Measure = IF(ISFILTERED('Table'[Column3]),MAX('Table'[Column3])," ")

Best Regards

Janey Guo

 

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