Matrix to chart

[Anonymous]

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 and delivered across time for each team.

Team	Products	Week1	Week2	Week3	Week4
A	Committed	20	20	25	22
A	Delivered	15	20	17	18
B	Committed	30	59	48	45
B	Delivered	48	47	45	46

Any suggestions on the best way to present the data and how can I get there? 

[Anonymous]

Hi @Anonymous ,

To compare the values based on Time or to get the trend, a Line chart would be the best way to represent your situation.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

[Pragati11 · Accepted solution]

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]

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