Forum Discussion

PrakashPalle's avatar
PrakashPalle
Helper II
11 months ago
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...
Need Help
  • MasonMA's avatar
    MasonMA
    11 months ago

    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.

MasonMA's avatar
MasonMA
Super User
11 months ago

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.

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    11 months ago

    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.

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      10 months ago

      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.

      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        10 months ago

        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.