Override leave entries within a calendar matrix

[robhel]

Hello PBI Guru's

I havve created a leave calendar merging 3 different data sources:

Annual Leave Report

Work Schedule Report

National Public Holidays

And inclded a measuere for conditional formatting to colour code the leave types, however what I would like to do is overwrite the leave types in accordance with:

1st Public Holidays

2nd Any Leave over RDO's

As within the first screen shot, eg all days on 01 Tue to be grey and all days on 04 Fri that are AL that have an RDO, to be green with AL

I have a Leave Type table - which for 0 RDO & 1 PH have been created manually for reference and was hoping for guidance on a way to use this table to override leave requests

Appreciate any suggestions on this one

[robhel · Accepted solution]

I figured it out, that I had to remove the duplicated rows in my source data - thanks for viewing my question thou