Forum Discussion
Power BI Matrix Column Assistance
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!
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
3 Replies
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
