Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
84 | |
64 | |
52 | |
49 |
User | Count |
---|---|
211 | |
87 | |
80 | |
69 | |
60 |