Forum Discussion
Helper IVDynamically highlight rows of a table based on the data.
Helper IVHi 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.
Super UserHey 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
- Learner_SG
Hi TomMartens ,
this will be having real time data collection once implemented.
So what I need is that ,I have to come up with a logic which will be changing each day based on the last week data.
The expected result is that it has to show the recommended cleaning schedule for 4 timings (in the dashboard)based on the last week same day occupancy count and water usage for the urinal and water closet.Is it possible to come up with a logic based on the the provided data?
- TomMartens
Hey Learner_SG ,
if you have real time streaming data, you have to get familiar with using realtime streaming datasets. The video by Reza Rad shows how can incorporate measure in combination with streaming datasets: Writing calculations on a real time streaming Power BI dataset using DAX measures - YouTube
To answer your question: Yes it's possible, but nevertheless you did not provide the algorithm on how to highlight the schedules.Regards,
Tom- Learner_SG
Hi TomMartens ,thank u for the reply. I need to come up with an alogirthm as nothing else is provided from the client side and I am clueless how to proceed with the informations that I mentioned in the previous msgs.