Forum Discussion

lehikk's avatar
lehikk
Icon for Helper I rankHelper I
6 years ago
Solved

Real-time dashboard gauge decimals

I have a system that pushes real-time data to a Power BI live dashboard, which is mainly using the simplified gauge visualizations that the live dashboard offers. Is it still (in 11/2019) the case th...
General Comment
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi lehikk ,

     

    We can use the following workaround if you are using the Push Dataset with historic data analysis.

     

    1. Connect the dataset use the Power BI Desktop.

    2. Create a measure use timestap to get the latest value or other calculate logic

    3. Set the format of measure as Whole Number

    4. Create the guage decimals use this measure

    5. Publish this report into Power BI Service, pin this value to the dashboard you want

     

     

    But it will have a several second delay with the real time title.

     

    We also not found an effective solution to achieve your requirement with real time guage title, perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner :https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lehikk's avatar
lehikk
Icon for Helper I rankHelper I
6 years ago

Hello v-lid-msft 

 

Thanks for the advice. Unfortunately, it did not work as expected. The problem is that the tile is not updating at all on the live dashboard. You mentioned about several second delay, but the tile does not refresh unless I reload the page. The actual "live gauge tiles" do update, which mean that there are changes happening in the dataset.

 

Actually getting the latest value was the hardest part, as I my "timestamps" have multiple values for the same date, which made many of the date functions useless. Finally it was pretty simple with TOPN function, but it took some time to realize how to use it.

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi lehikk ,

 

Glad to see that you found the way to get latest data, but the auto refresh seems works on my side. We test it in PowerShell API with a historic streaming data.

 

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • lehikk's avatar
    lehikk
    Icon for Helper I rankHelper I
    6 years ago

    Hi v-lid-msft ,

     

    When I'm about to use the "Pin to dashboard" -feature, Power BI displays a message saying:
    "Pin live page enables changes to reports to appear in the dashboard tile when the page is refreshed."

     

    That emphasized part seems to imply that the page needs to refreshed to see the changes. I wonder if there's some spesific settings considering the auto refresh in dashboard, report or dataset settings?