Forum Discussion
Power BI Matrix Chart – Static and Dynamic Column Configuration
HI PrakashPalle
First normalize your data by Unpivoting as below so that it gives you a flexible matrix that updates automatically as new months are added or filtered.
For Matrix, simply add Category, Sub Category, and KPI to Rows, Month to Columns and KPI Value to Values.
HI PrakashPalle
First normalize your data by Unpivoting as below so that it gives you a flexible matrix that updates automatically as new months are added or filtered.
For Matrix, simply add Category, Sub Category, and KPI to Rows, Month to Columns and KPI Value to Values.
Hi PrakashPalle
We’d like to check if you were able to go through the previous response provided by MasonMA to your issue. Please let us know if you need further clarification we’ll do our best to support you.