Forum Discussion
Helper IVDynamically highlight rows of a table based on the data.
Super UserHey Learner_SG ,
please consider creating a pbix file that contains sample data but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix file to onedrive or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method, please share the Excel file as well.
Please explain the expected result based on the sample data you provided.
It's also important that you share the business rules, like how a high usage is defined.
Regards,
Tom
Helper IVHi TomMartens ,sorry for the delay in sendin the data. Due to sensitivity of the data nature, I have copied some sample data of the required part and saved it in the excel file.
My current requirement is that based on the occupancy status which is found by (Occupied_status)and water consumption of the urinal(UR water consumption(mL)) and Water Closet (WC Water Consumption(mL)) I need to come up with a recommended cleaning schedule for the male ,female and Handicap toilets.
Currently the condition set is:
For this week Monday, Power BI should check last week Monday’s usage. For Every 1 hour- check for the occupancy count and water usage of the toilets(eg:male). if higher than a limit set(average usage of that particular day) ,then We have to select 4 cleaning schedules which is at least a gap of 2 hours between(8 to 10PM) and display it in the dashboard table .
So, this schedule will change every day based on the corresponding last week same day usage.
I have attached the excel file data. and the sample dashboard.Thanks in advance for the help.