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

Nolock's avatar
Nolock
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi hnguy71,

check out the feature Drillthrough in Power BI. It allows you to navigate to different report pages while applying filters set on the previous report page. In the following video you can see more: Youtube Drillthrough

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!