Forum Discussion
Displaying cross sectional data in one visual
This is a conceptual question on how to best organize the data to get one visual used by several tables. In other words, aggregating data compactly in one place instead of showing 20 different tables...
Thanks a lot for your effort! I ran in the following problems. First is that I cannot open the file:
I only have Power BI Desktop in use.
Also, when I create in my environment the Product and Category tables, I can link the Product Categories only in one-to-many (or many-to-one). Category Table I could not link at all to ProductA and ProductB tables ("one of the columns must have unique values"). Not sure if the issue is that there is a time dimension, so naturally Level1 and Level2 are repeated over time, just like "4 Doors" appears on two dates in the original post.)