Forum Discussion
Cannot get the correct data model for matrix table
Hello All ,
I intended to present the data in a specific format, but I am encountering challenges when it comes to displaying the Unit of Measure (UoM) column within the matrix table . With unpivot table and star-schema structure , I am able to arrange my table as below except for column UoM.
Can anyone please guide me on this ? Thanks !
- This is my raw data after I have unpivot columns and structure it with a star-schema model.
1 Reply
Hi miss_L
The new dynamic format strings for measures is probably what you want.
Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn
If this doesn't help, can you show some sample data before you unpivot columns and the final expected result in a matrix visual?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
