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 is no "Don't Summarize" option when I click on the little arrow at the right of the value.

 

My question is :

 

Is this the normal gauge widget behavior or is there something wrong with the way I use it ?

 

Thank !

  • bgauvreau

     

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

6 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    bgauvreau

     

    That is the normal behavior.

     

    When attempting to "Don't Summarize", what would you like to get with a Gauge Widget? I don't quite get the idea "real time value" in your case, if you mean something like" the latest", it is still a "Summarize".

    • bgauvreau's avatar
      bgauvreau
      Advocate I

      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

        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 ]
        )