Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts,
Need your help in this.
In our data model we have got a dimension which has no relationshup with Fact Table. The structure is as follows:
As shown above, in the Category dimension we have category name in Rows and in Fact table we have individual columns for each category name.
The expected output is :
I have tried an option of unpivoting the fact and create the relationship with Category dim. It works fine but increase the number of rows which is not ideal.
Please advise what would be the best solution for this type of data model.
Thanks.
Solved! Go to Solution.
Hello @Anonymous
Unpivoting your fact table is the way to go. PowerBI is very good at handling tall narrow tables and they give you the most flexibility as well.
You've done it already.
Don't worry about the increase in rows.
Hello @Anonymous
Unpivoting your fact table is the way to go. PowerBI is very good at handling tall narrow tables and they give you the most flexibility as well.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |