Forum Discussion

gconnolljr's avatar
gconnolljr
New Member
8 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
    8 years ago

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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 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
8 years ago

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