Forum Discussion
Matrix with Dynamic Row/Column Headers
Hi! Let's say I have a table with the columns: ID, Attribute 1, Attribute 2, Attribute 3... where each of the attribute fields can be either A, B or C in value. I'm trying to create a matr...
BenjyPowerBI , Unpivot this data. That will give Attribute and value , Use Attribute and value both row and column and do count of ID
https://radacad.com/pivot-and-unpivot-with-power-bi
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hey Amit,
The inclusion of an unpivot table makes the .pbix file size way too big to work with (and publish) so I need a workaround using DAX if possible 😕
Work with a filtered dataset to reduce the size and reconnect to the full dataset once published
Hi Paul I'm not sure what you mean by this. Please could you elaborate? 🙂 And how can I reconnect to the full dataset after it's been published?
Thanks in advance!
