Forum Discussion

scpm's avatar
scpm
Regular Visitor
8 years ago
Solved

Matrix Visualization - Changing the Value displayed based on drill down level

Hi Everyone-   I'm trying to use the out of the box Matrix visualization and the built in drill down features and I'm stuck on something.   The data has a parent-child relationship in 2 different...
General Comment
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi scpm,

     

    I believe that you need something in the line of this article to this article from @marcorusso, in this article the hierarchy are calculated based on the path that each hierarchy level has then based on that we do a lookup of the previous level.

     

    The several levels of hierarchy are calculated in hidden columns then we use to make the final calculations based on the measures we need.

     

    I have made a similar example for another post please check the PBIX file attach this one is making count but measures can be changed to sum or other things.

     

    Check the article in detail and the PBIX file attach with the solution.

     

    Regards,

    MFelix

scpm's avatar
scpm
Regular Visitor
8 years ago

Thanks for the quick reply MFelix .

 

If I'm understanding the solution correctly, I would need to build a new table that is in the form of:

 

 

ID       Name      ParentID     [Other attributes I may want]

 

The new table combines the Parents and Children into the same table, and leaves the ParentID blank for any of the Parent items.  At which point, I can base everything on the Hierarchy pbix from your last message.  Or did I misunderstand?  Let me give this a try and see how it works.  Thanks!

MFelix's avatar
MFelix
Super User
8 years ago

Hi scpm,

 

You need to identy for each child theyr parent ID and then everything should work. As a best practice probably the best way is to have a seperate table for this.

 

If you need any help on this please tell me.

 

Regards,

MFelix