Forum Discussion

rosscortb's avatar
rosscortb
Post Patron
6 years ago

Annual Leave Matrix

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 

Need Help

2 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    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's avatar
      rosscortb
      Post Patron
      6 years ago

      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