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.
Hello Community,
Can I kindly request assistance with the following matrix column issue:
Reffering to the PRIORITY column, I need to simulate the following results from Excel in Power BI:
TEAMS | PRIORITY | JANUARY | FEBRUARY | MARCH | . . . . .
APP 1 - High 4
2 - Medium 13
3 - Low 23
DBA 1 - High 1
2 - Medium 11
3 - Low 34
CSIT 1 - High 2
2 - Medium 15
3 - Low 9
If I have Columns: TEAMS, PRIORITY, DATE CREATED and RESOLVED, how do I list the three values for PRIORITY (High, Medium and Low) for each TEAM to count the values of RESOLVED for each DATE CREATED as per the example above.
How can I achieve this column for a Matrix in Power BI?
Thank you for the help!
Solved! Go to Solution.
Hi @kevinsmith27,
What does your original data look like? I would suggest you create three dimensional tables. Please refer to the demo in the attachment.
Best Regards,
Dale
Hi @kevinsmith27,
What does your original data look like? I would suggest you create three dimensional tables. Please refer to the demo in the attachment.
Best Regards,
Dale
Hi @v-jiascu-msft,
Thank you very much for the reply, your demo really helps.
Could I kindly request assistance on how to achieve what you did in your demo with my original dataset. All my data is part of one Excel table as below (Required fields highlighted):
Currently my Matrix Table looks as below:
I need to find a way to insert the priorities column as per the example in your demo, but I am usure how to do this without dimensional tables, all my data is part of a single Excel table. How do I achieve this?
Example data as below:
Thank you for the help!
Hi @kevinsmith27,
If we don't have dimensional tables, some values could be missing. Please refer to the snapshot below.
1. Extend to the next level.
2. Don't establish a relationship with other tables through Date column. Then we can use the date hierarchy.
Best Regards,
Dale
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |