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
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
4 years ago

Hey 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

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    4 years ago

    Hey Learner_SG ,

     

    please explain the expected result based on the data you provided, also it not clear how to consider the status field, as there are blanks and the value "yes".

    What else does a DAX statement has to consider what currently is not in the below matrix visual:

    For example, explain your expected result for the 27th of February, and a 2nd day.

     

    Regards,

    Tom

     

    Thanks,

    Tom

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

      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

       

      • TomMartens's avatar
        TomMartens
        Icon for Super User rankSuper User
        4 years ago

        Hey Learner_SG ,

         

        please describe the expected result based on the data you provided.
        It's not necessary to use DAX, instead you can use some prose, like
        For the 27th of January I expect the following recommendation

        ...

        because

        on the 20th of January the data was this and aggregating the data like that will provide the expected result.

         

        Regards,

        Tom