Forum Discussion
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 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?
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
3 Replies
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