Forum Discussion
Helper IReal-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.
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.
5 Replies
v-lid-msftCommunity 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
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
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
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
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.