Forum Discussion
Solved
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...
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 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.
Hi PrakashPalle
Just checking in to see if the previous response helped resolve your issue. If not, feel free to share your questions and we’ll be glad to assist.