Forum Discussion

gconnolljr's avatar
gconnolljr
New Member
9 years ago
Solved

Get drill down hierarchy level from Axis on column chart with DAX?

Does anyone know how to detect/get the current hierarchy level from “Axis” on a column chart?   For example, say I have a 4 column table with 10 records: Column [National] with value of “All” Col...
Tips and Tricks
  • gconnolljr's avatar
    gconnolljr
    9 years ago

    Makes sense. Thank you very much for your help Qiuyun Yu.

gconnolljr's avatar
gconnolljr
New Member
9 years ago

That's pretty slick...thank you!

 

I can see it working when I choose to "Go to next level in the hiearchy", but not if I try to "Expand to next level in the hiearchy".  Got any magic for that, too?

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi gconnolljr,

 

If current level is National, use "Expand to next level in the hierarchy" action will have National and State both be filtered, so the previous measure doesn't work. You can create a measure below: 

 

ExpandNextLevel = IF(ISFILTERED(Table1[National]) && ISFILTERED(Table1[State]) && ISFILTERED(Table1[City]),3,IF(ISFILTERED(Table1[National]) && ISFILTERED(Table1[State]),2,IF(ISFILTERED(Table1[National]),1,BLANK())))

 

Please note this measure will not work when use "Go to next level in the hierarchy". We can't catch the current level use one measure for both "Go to next level in the hierarchy" and "Expand to next level in the hierarchy". 

 

Best Regards,
Qiuyun Yu 

 

 

  • gconnolljr's avatar
    gconnolljr
    New Member
    9 years ago

    Makes sense. Thank you very much for your help Qiuyun Yu.