Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am new to PowerBI, I have a table containing 4 columns equipmentName, equimentStatus (enumeration), equipment in use (binary), and start and endtime (date). the objective is to create a table to track the status of the equipment on an hourly basis per day (the table will have 24 columns representing each hour of the day and the rows represent the list of the equipment, how to populate the table with the status based on the start and end time. the end goal is to obtain a heatmap table to display the status of the equipment hourly during a day based on the events table. what is the best approach?
Thanks in advance for your support.
Solved! Go to Solution.
Here's a rather feeble attempt to do this with a standard visual. Might be better off looking for a custom visual.
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hello,
Below a sample of the status change events table and the desired status chart per machine
Thanks
Please provide sample data in usable format.
Name | AssetStatus | StartDateTime | EndDateTime |
CCA04 | En panne | 8/27/2022 10:00:00 AM | 8/27/2022 12:00:00 PM |
CCA04 | Disponible | 8/26/2022 12:00:00 AM | 8/27/2022 10:00:00 AM |
CCA04 | Disponible | 8/27/2022 12:00:00 PM | 9/1/2022 12:00:00 AM |
CNA6 | En panne | 8/27/2022 8:00:00 AM | 8/27/2022 12:00:00 PM |
CNA6 | Disponible | 8/26/2022 12:00:00 AM | 8/27/2022 8:00:00 AM |
CNA6 | Disponible | 8/27/2022 12:00:00 PM | 9/1/2022 12:00:00 AM |
thanks you lbendlin, this should put me on the right track!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |