Forum Discussion
Power BI Matrix Chart – Static and Dynamic Column Configuration
Hi Power BI Experts,
I’m trying to build a matrix chart in Power BI based on the structure shown in the attached screenshot. In this setup:
- The first three columns — Category, Sub Category, and KPI — are static and serve as identifiers for each report.
- The remaining columns represent monthly data from January to December and are dynamic.
These static columns are not part of the report dataset itself but are essential for mapping each row to its respective category and sub-category. I need guidance on how to model this in Power BI so that the static columns remain fixed, while the monthly data updates dynamically.
Could you please advise on the best approach to structure the data or configure the matrix chart accordingly?
Thanks in advance for your support!
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.
4 Replies
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.Hi PrakashPalle
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.If you have any question relating to the current thread, please do let us know and we will try out best to help you.
