Forum Discussion

bgauvreau's avatar
bgauvreau
Advocate I
10 years ago
Solved

Gauge Widget - Real Time Value

Hi,   I want to display a real time value in a gauge widget for an operational dashboard. But when I select the value to be displayed in the widget, I only have access to summurized values. There i...
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    bgauvreau

     

    To bypass the 8 updates limitation, why not use the DirectQuery mode? No schedule refresh is needed then.

bgauvreau's avatar
bgauvreau
Advocate I
10 years ago

Hi Eric,

 

Your right, I mean the latest value..

 

I'm working on an industrial IoT project using Azure microservices, including Power Bi.

I want to use the gauge visual to show the temperature of an industrial equipment in real time. I want the latest real measure, not any kind of agregated data.

 

I could have used a line chart and point the last dot to read the latest data but...

 

I plan to use the new Power Bi Augmented Reality to allow the equipment operator to scan a QR code to find out the real time temperature of the machine. A line chart is not a good option in this context.

 

 

Do you have any idea of what I could do with Power Bi to achieve this goal. Maybe some resource or example project I could take inspiration of ?

 

Thanks

 

Bertrand

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

bgauvreau

 

So you're talking about something on Power BI mobile, while I don't really know much.

Regarding the Gauge Widget and "latest", you can reference a measure as below.

 

Measure =
AVERAGEX (
    FILTER ( ALL ( 'Table' ), 'Table'[datetime] = MAX ( 'Table'[datetime] ) ),
    'Table'[temperature ]
)