Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi
I am trying to create a synoptic panel floor plan looking like this
My aim is to show the live status of the doors & windows. It isnt quite working though. It isnt pulling the latest row through to the panel.
My data looks something like this;
The closed column is a measure with the following DAX
closed = IF(CONTAINS(RealTimeData,RealTimeData[state],"NOT_PRESENT"),0,1)
and Last Closed State is another measure which isnt working correctly though. This has the following DAX
LastClosedState = IF ( HASONEVALUE ( RealTimeData[area2]), VAR LastTime = MAXA(RealTimeData[createTime]) VAR Result = CALCULATE (RealTimeData[closed] , RealTimeData[createTime] = LastTime ) RETURN Result )
My dataset is being inserted from MS-Flow via an API. when a door or window opens or closes it inserts another row with the current status and this is what i want the synoptic panel visual to view and not the previous rows in the dataset.
I have a deadline for this friday to get it working and for the panel to be updating when someone opens/closes the window or door. I hope someone is able to guide me in the right direction and get the floorplan working correctly.
Hi ChrisWeeks92,
For further analysis, could you share your connection string or rest api connection details in your power query code?
Regards,
Jimmy Tao
Hi @v-yuta-msft
My JSON connection is this
{ "type": "object", "properties": { "event": { "type": "object", "properties": { "eventId": { "type": "string" }, "targetName": { "type": "string" }, "eventType": { "type": "string" }, "data": { "type": "object", "properties": { "temperature": { "type": "object", "properties": { "value": { "type": "integer" }, "updateTime": { "type": "string" } } }, "touch": { "type": "object", "properties": { "updateTime": { "type": "string" } } }, "objectPresent": { "type": "object", "properties": { "state": { "type": "string" }, "updateTime": { "type": "string" } } } } }, "timestamp": { "type": "string" } } }, "labels": { "type": "object", "properties": { "name": { "type": "string" }, "area": { "type": "string" }, "area2": { "type": "string" } } } } }
and the data is being pushed to the flow url which is then being added into the live Power BI dataset
Does this help?
Sorry to post again, but can anyone help me as i need to get this over to my boss by monday.
Ultimately i am after the latest row only from each area2 and the status of whether they are open or not.
I am using api/live data so i can only create measures.
Any help is much appreciated
User | Count |
---|---|
129 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
63 | |
54 |