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.

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
5 years ago

Hi vr_2020 , you are right about default behavior, but I noticed that you did not set this value as a hierachy.

 

 

See the pic above, the upper set is set as a hierachy, and I turned of the title.  Perhaps closer to what you are looking to doing?
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

vr_2020's avatar
vr_2020
Frequent Visitor
5 years ago

Thanks Nathaniel_C for the quick reply. I don't think setting up as a Hierarchy and turning off the Title will  have an significant impact on the default behavior about the point (as marked in red) that I am looking for.