Forum Discussion

hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago
Solved

Cascading Tables Improvements?

Good evening, All!   I have a table that has different work types: Epic, Feature, and Backlog. If a user selects an upper level work type, the lower levels (feature and backlog) filters accordingly...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    hnguy71  - You want to "flatten" the parent child hierarchy. You can see a DAX method here or an M method here.

     

    The idea is that your new table will have a column for each of your attributes (Work Type, Epics, etc). 

     

    Cheers!

    Nathan

hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago

Hi Nolock 

 

Appreciate the post but that's really not what I'm after. I'm aware of the drillthrough feature but let's say I'm an excutive without Power BI knowledge looking at a dashboard he or she probably wouldn't know how to drillthrough or navigate in and out of it. The idea is to make selections cascade dynamically and to easily navigate the page. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hnguy71  - You want to "flatten" the parent child hierarchy. You can see a DAX method here or an M method here.

 

The idea is that your new table will have a column for each of your attributes (Work Type, Epics, etc). 

 

Cheers!

Nathan

  • hnguy71's avatar
    hnguy71
    Icon for Super User rankSuper User
    7 years ago

    nice! I'll look into it further! Definitely closer to what I'm thinking! Thank you!