Dynamically highlight rows of a table based on the data.

Hi TomMartens ,

With the matrix visual that you have come up with  is a bit confusing for me to explain.I will try to elaborate more on the data sample below and have removed more columns which maybe misleading and also the blanks.

The column A - displays the occupied status of the toilets based on the time(column B).

                           If "yes" it means occupied at that particular time.

    Column D and F- Consumption amount of water in the Urinal and Water Closet.

   Column K - is the date  

   Column L  - is the hour of the occupany (eg:2nd hour in the 24 hour time)

   Column M- Gender

   Coumn N - is the unit location (WC Glass flush valve F04) -meaning Water closet Female

   Toilet 4.

Based on this data, I need power bi to understand how much is the occuapncy of the toilets for male/female/handicap and also the consumption of water in the urinal/water closet for the 3 type of toilets(male/female/handicap) and when I select each type of toilet(m/f/hcp) in the dashboard, it should show me in the table the recommended cleaning schedule for that particular day. 

I hope this might clarify your doubt and if you need any more info ,please let me know.

Since I am new to Power BI , unable to come up with the DAX for the recommendation table.

Thanks!

have updated the data and removed the misleading the blanks/ misleading.

https://docs.google.com/spreadsheets/d/15N2Vqx1tAGvg6bzLbBaRClUkWMpBlkA9/edit?usp=sharing&ouid=106716879610449662390&rtpof=true&sd=true