cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

ERROR, a leading zero of % in dashbord and report

This is a error i just found today, in all of the chart of my report and dashbord, all the data in format % had a leading zero in plusplus zero error 1.pngthis is a chart in a report

 

And this is from my dashbord

plus zero error 2.png

 

 

But they were

7 REPLIES 7
Highlighted
Community Support
Community Support

Hi YuanG,

 

Based on my test, there is no prefix 0 in the percentage values both in reports and dashboards. In your scenario, which data source you were connecting to? Did any person modify the reports or dashboards recently? Was there any update on data source side? Please share more detail information with us so that we can try to reproduce the issue.

 

Also you can create a simple report in Power BI Desktop, drag a chart or card into the report to display a measure which calculate percentage values(##.##% format ). Then publish it to service to check if 0 is prefixed.

 

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Regular Visitor

Hi,

 

I am using the French localization of power BI too, and I am facing now the same issue.

I have just switched from the july version of power BI to the august version (2.38.4491.282 64-bit) without changing the data nor the reports.

Sometimes, the percentages are displayed without leading 0.

For the chart on the right hand side, if I change the format with no decimals (integer), the percentages loose their leading 0, even the 7% line. If I get back to 1 decimal, the leading 0 are back too.

2016-09-06 17_18_07-reporting online - Power BI Desktop.png

Highlighted

Hi rickenbroc,

 

Based on your description, I create a simple sample, but it works well on my side, below is the steps:

 

 1. Download the newest power bi desktop version.

Capture.PNG

 

 2. Set the localization to French.

Capture2.PNG

 

3. Create four visuals.

 

4. The result on desktop and service.

 

Desktop:

Capture3.PNG

Service:

 Capture4.PNG

 

Since I can’t reproduce your issue, can you provide a reproduce sample? Or could you please download attached .PBIX file and publish to your service to check if the data labels display correctly?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted

Hi Xiaoxin Sheng,

 

I have downloaded your file and the leading zeros are presents :

First, I have verified the current version of Power BI Desktop.

I also tried to change the file localization, but I did not cure the issue, and I did not find a way to change Power BI language.

 

2016-09-07 10_36_22-chart lead percent - Power BI Desktop.png

 

Then, if you look at the tooltips, percentages are correctly displayed, but not the rendering in the charts
2016-09-07 10_38_34-chart lead percent - Power BI Desktop.png2016-09-07 10_39_13-chart lead percent - Power BI Desktop.png2016-09-07 10_39_29-chart lead percent - Power BI Desktop.png

Best Regards,

Rickenbroc

Highlighted

@rickenbroc@YuanG, thanks for reporting this issue. It can be reproduced on my side in the French Power BI Desktop. I will report it internally to ask senior engineers to have a check. Will post back for any updates. 

Highlighted
Microsoft
Microsoft

@rickenbroc, @YuanG

 

This issue should be fixed in the latest Version : 2.39.4526.362 32-bit (September 2016). Please update your PBI Desktop and have a try.

ERROR, a leading zero of % in dashbord and report_1.jpg

 

Best Regards,

Herbert

Highlighted

Hi,

 

I have checked my file and the sample you provided to me and everything is fine now 🙂

 

Thanks for your support !

 

Eric

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors