Forum Discussion
Matrix with Dynamic Row/Column Headers
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!
Here are a couple of links which will help (I hope!)
Edit parameters settings in Power BI service
Change the source of PowerBI datasets dynamically using Power Query parameters
So basically you create a parameter to filter down the dataset to a manegeable level, and once published, you edit the parameter in the service.
OR, work with a filtered sample and then alter the source from within the service to pull the whole dataset (as per link number 2)
