Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
lehikk
Helper I
Helper I

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 that the data formatting is fixed with the live gauges? I have defined a "number" type field to the API, and it seems to always default to 2 decimals even if I pass an integer (1 becomes 1.00). My client is asking to remove the extra decimals as they are not important in this case...

 

Do we have any hopes of seeing improvements to the live dashboard visualizations in the near future? Currently they are not very useful for some cases, as there is so few options you can modify.

1 ACCEPTED SOLUTION
v-lid-msft
Community Support
Community Support

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

 

8.PNG

 

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.

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.

View solution in original post

5 REPLIES 5
lehikk
Helper I
Helper I

Ah, got it. I was trying to pin the whole report, not just the visual AND earlier I was unable the pin just the visual, because I had set the Visual Header to "off" which made it impossible to click the Pin button. Not the best UI decision in my honest opinion...

 

Thanks.

v-lid-msft
Community Support
Community Support

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

 

8.PNG

 

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.

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.

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.

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.

 

ezgif-2-659bcb687fcd.gif

 

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.

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.

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.