Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |