Forum Discussion

Learner_SG's avatar
Learner_SG
Icon for Helper IV rankHelper IV
4 years ago

Dynamically highlight rows of a table based on the data.

Hi , I have a job requirement in which the power bi has to assess the data based on the last week usage/consumption of the toilet/rooms and recommend the cleaning schedule for the current day. To exp...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, Learner_SG 

 

Can you provide a simple PBIX file for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Learner_SG's avatar
    Learner_SG
    Icon for Helper IV rankHelper IV
    4 years ago

    Hi v-zhangti  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.

     

    https://1drv.ms/u/s!AspD-EyWu948gi1bwJZbLNQIlW1K?e=DWYK1N