Multiple Values in One Matrix Table

[Anonymous]

Hi there,

I have this one calculated table like this:

Staff  | Date          | Duration  | Passed?   | Failed Repeater

A       | 1/1/2021   | 230          | Passed    | Not Repeater
A       | 1/2/2021   | 110          | Failed      | Not Repeater
A       | 1/3/2021   | 100          | Failed      | Repeater

A       | 1/4/2021   | 230          | Passed    | Not Repeater
A       | 1/5/2021   | 90            | Failed      | Not Repeater
A       | 1/6/2021   | 100          | Failed      | Repeater

In this table, [Passed?] column checks if the staff pass or fail and [Failed Repeater] column checks whether the staff fails in that month and also fails the previous month. We also have multiple staff and months.

I would like to produce this table in my dashboard:

In this table, the green coloured cells are the number of staff that failed in that month for the first time. And the yellow coloured cells are the repeater. At first, I thought this table is impossible to be produced in Power BI, but I would like to know from the experts if there are workarounds or possible ways to achieve this.

For now I only can come up with separate tables for Failed staffs, and another one for Repeaters. I would like to combine these two to be like the one in the image.

Thank you in advance!

[Kishore_KVN]

Hello @Anonymous , this is possible with the MATRIX visual and conditional formatting options but the main activity is creating a data table in proper way for which you have to do some transformation options and clean the data as required. 

Please let us know if you face any challenge while developing. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Anonymous]

Hi, can i get any suggestions of how or what kind of data table that i need to produce first?