Annual Leave Matrix

[rosscortb]

Hello,

I am trying to make an annual leave calendar based on this vid  - https://www.youtube.com/watch?v=SO4mk1H94OA

and this link - https://willmi77.wordpress.com/2018/11/21/project-timeline-reporting-in-power-bi/

but Im struggling, want to show Approved dates in one colour and Submitted in another on a row running each day.

Not sure going about it right way, but I do know it has to be done in a matrix rather other visuals.

see file. Any would be appreciated. Rosshttps://drive.google.com/open?id=1eJOMP8kMtfUzapeo_nAV844HS_XJ6_G4 

[v-eachen-msft]

Hi @rosscortb ,

I still don't understand your requirements totally. Do you mean to show two kinds of color in one table or each table?

[rosscortb]

one table.

so it looks something like this,  Month and Day and you can scroll to end of year

Red - Approved

Gren - Submitted

Hope that makes sense. Thanks Ross