Forum Discussion

Helper I

2 years ago

Visualize Data in Matrix Table based on Dropdown - Issue with Dropdown

Dear Community, I am having some issues with visualization of a matrix table. I hope it can be solved either with changing the layout of the visual or with an additional measure. There is no pos...

Super User

2 years ago

There is no possibility to change the data set much.

Your data is not in a format that is usable in Power BI.

tim_001
Helper I
2 years ago
Thanks a lot for the feedback. Do you know how I could restructure the table to get the desired result?
- lbendlin
  Super User
  2 years ago
  You have many options to represent your ragged hierarchy - Here is one example (and it links to others)
  
  Parent-Child Hierarchies with multiple parents in Power BI with Power Query (thebiccountant.com)
  
  The table structure (and the data model) ultimately have to follow the user requirements. So if you need to be able to filter by product then you need to have a product column at the atomic level (and the associated hierarchy).
  - tim_001
    Helper I
    2 years ago
    Thanks a lot. It looks like I need to spend some time to figure it out in detail but I get the idea.
    Is it correctly understood that first step would be changing the table to look similar like that?:
    
    Because I have the data in a data-base friendly format, could I not create another table in Power BI itself and make a function if it is Level 1 then put it in the columne, otherwise empty?
    
    I am just asking because it was mentioned that I would need to change my dataset but if I could do it like that, then I would not have to change the data set but only transform it into another table. Not sure if it will work 🙂 It sounds a bit too optimistic from my end. Thanks a lot again for the tips and links.