cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
helenah Regular Visitor
Regular Visitor

Gauge visual shows different number of decimals in dashboard than in Desktop

I have used the Gauge visual in showing some results in Power BI. Up until recently, it has worked well. One ogf the report users just notified that the Gauge shows currently two decimals for all values although in Desktop there are no decimals and I have also made sure that the Format is set to 0 decimals and even the format is "Whole number".

Has anyone else noticed the same and is this a bug, or something I can do to fix it? The report now looks very stupid.

 

Capture.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-caliao-msft
Moderator

Re: Gauge visual shows different number of decimals in dashboard than in Desktop

Hi @helenah,

 

He issue is caused by average function. Based on my tested, the Average function in Value will keep two decimals in Power BI services. In order to avoid this issue, you can create measure like
AverageScore = AVERAGE(Table1[Score])
AverageMin = AVERAGE(Table1[Min])
Averagemax = AVERAGE(Table1[Max])
Capture.PNGCapture1.PNGCapture2.PNG

 

Besides, I will report this issue and hope this will be resolved in next release.

 

Regards,

Charlie Liao

5 REPLIES 5
Moderator v-caliao-msft
Moderator

Re: Gauge visual shows different number of decimals in dashboard than in Desktop

Hi@helenah,

 

Which data type are you using? Could you please provide us a screenshoot of you source table? I have tested it on my local environment, we cannot reproduce this issue.

Capture.PNG

 

Regards,

Charlie Liao

helenah Regular Visitor
Regular Visitor

Re: Gauge visual shows different number of decimals in dashboard than in Desktop

Hi @v-caliao-msft,

 

Data type is whole number. I forgot to mention, that I have the average of that field in the gauge. I made a simple example power bi file which I could share with you by email.

 

Meanwhile, snapshots of my data and report below.

 

Capture1.JPGThis is the data tableCapture2.JPGThis is how the gauge is definedCapture3.JPGThis is again the data type of the same field in the report view

helenah Regular Visitor
Regular Visitor

Re: Gauge visual shows different number of decimals in dashboard than in Desktop

Hi,

 

This is a link to an example Power BI file I created to show this problem:

 

https://drive.google.com/open?id=0B47qZ88gRy8EcjIwZl9GTkN1YkE

 

@v-caliao-msft

 

Are you able to reproduce this issue? Is it a bug or can I fix ift somehow?

Moderator v-caliao-msft
Moderator

Re: Gauge visual shows different number of decimals in dashboard than in Desktop

Hi @helenah,

 

He issue is caused by average function. Based on my tested, the Average function in Value will keep two decimals in Power BI services. In order to avoid this issue, you can create measure like
AverageScore = AVERAGE(Table1[Score])
AverageMin = AVERAGE(Table1[Min])
Averagemax = AVERAGE(Table1[Max])
Capture.PNGCapture1.PNGCapture2.PNG

 

Besides, I will report this issue and hope this will be resolved in next release.

 

Regards,

Charlie Liao

helenah Regular Visitor
Regular Visitor

Re: Gauge visual shows different number of decimals in dashboard than in Desktop

Thank you @v-caliao-msft for replying. The average used to work OK in the previous PowerBI Desktop version, it is only the recent one that shows the decimals with averages in Gauge. I have had the same report running for months and only now it does not work as expected. Really hoping it will be fixed soonest. Your solution is an OK workaround, but with the number of Gauges I have on my report, it is just too much work.

 

br,

Helena

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 50 members 1,171 guests
Please welcome our newest community members: