Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix to chart

Hi all; I have the below matrix, and I'm trying to create a visual from it. The problem is that I can't get PowerBI to present the data correctly. I need to show the comparisson between committed an...
Need Help
Tutorial Requests
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

     

    I am considering input data in the following format as you haven't added any information about it:

     

    You can try a bar chart as shown below based on the data above:

     

    Other option could be - Unpivot your data as follows:

     

    Then produce a chart as follows:

     

    But an additional detail around your raw data will be helpful to suf=ggest more visualisations.

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi Anonymous ,

 

 

I am considering input data in the following format as you haven't added any information about it:

 

You can try a bar chart as shown below based on the data above:

 

Other option could be - Unpivot your data as follows:

 

Then produce a chart as follows:

 

But an additional detail around your raw data will be helpful to suf=ggest more visualisations.

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks a lot for this!I took the approach of unpivoting the table which helped me present the data the way I needed.