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.

 

vr_2020's avatar
vr_2020
Frequent Visitor
5 years ago

Thanks Janey. Ideas looks great. It matches bit close to what I am looking for. I have got 5 hierarchy slicers which has got different levels of hierarchy in each of them in Main Page and the same is being used across multiple pages on the dashboard. Adding Card Visuals on top of the Slicers which is something I will have to think about it interms of having number of visual count on each page.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    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.