Forum Discussion
Multi hierarchical modeling
Power BI data modeling question – multiple deep account hierarchies I’m looking for the best data-modeling approach in Power BI for the following scenario. I have a DimAccount table that cont...
can you share some sample data in a pasted table we can easily copy into a pbix? I'm having trouble visualizing what your different hierarchies are and how they interact with each other and with a single account. If you can put names to it so my brain can process I may have a light bulb moment 🙂 or maybe it will inspire others.
In terms of the many : many problem, would you be able to concatenate the hierarchies with the account key to create a unique ID for the unpivoted accounts?
Multiple dim tables (one for each hierarchy) will stop you from putting all in a single slicer, but you should still be able to combine into a single matrix visual provided you also have something from the fact table in there - does that help any?