Forum Discussion
Need help to create a matrix table
Hi All
Need help in creating below table in Power BI as a matrix table.
1. Past months count should be filled with Green color. Previous month in Yellow color(i.e September month in yellow color).
2. Where it is written as build completed to be filled with green color
3. Project on hold to be marked as grey color.
| Product | Model | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 | Apr-23 | May-23 |
| A | ABC | 1 | 1 | 1 | ||||||||||||||
| XYX | 1 | 2 | 2 | |||||||||||||||
| ZZZ | 1 | 1 | ||||||||||||||||
| B | AAA | 2 | 6 | 4 | 8 | 12 | 12 | 12 | 12 | 12 | ||||||||
| BBB | 2 | 2 | 4 | 4 | ||||||||||||||
| CCC | 2 | 4 | 4 | |||||||||||||||
| C | DDD | 1 | 1 | 1 | ||||||||||||||
| EEE | 1 | 1 | 1 | |||||||||||||||
| FFF | bulid completed | |||||||||||||||||
| GGG | 2 | |||||||||||||||||
| HHHH | Project is in hold | |||||||||||||||||
| D | III | bulid completed | ||||||||||||||||
| TTT | 1 |
See if this works for you:
Sample file attached
5 Replies
See if this works for you:
Sample file attached
Can you please share sample data or a link to a PBIX file?
can u check if you can access the sample data.
What I meant was that we need a sample of the actual data in your tables (not the structure of the final matrix) so that we can build the matrix based on the structure you have