Power BI Matrix Column Assistance

[kevinsmith27]

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!

[v-jiascu-msft · Accepted 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

[kevinsmith27]

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!

[v-jiascu-msft]

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