Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 |
Solved! Go to Solution.
See if this works for you:
Sample file attached
Proud to be a Super User!
Paul on Linkedin.
See if this works for you:
Sample file attached
Proud to be a Super User!
Paul on Linkedin.
Can you please share sample data or a link to a PBIX file?
Proud to be a Super User!
Paul on Linkedin.
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
Proud to be a Super User!
Paul on Linkedin.
thats the input am having and i want to convert same to Power BI. The input file is also in same structure
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |