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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Value decimal places property does not work in PBI service after publishing

Hello!

 

I am using a stacked column chart and I want to see column Total labels with a decimal point.

 

It works fine in PBI Desktop. But when I publish it to the PBI service I get rounded values with no decimal. If I edit the report in the service, Value decimal places property does not respond.

 

Also Value decimal places property looks weird, and it changes to jus Auto when I hover over it:

VitalijaM_1-1667830736186.png

 

Status: Investigating

Hi @Anonymous 

I tested it in my Desktop and Service , there is no problem as you said. You can confirm if there is a problem with my steps? My test versions are Version: 2.110.805.0 64-bit (October 2022) and 13.0.19403.8 .

Recording 2022-11-08 at 14.06.40.gif

 

Best Regards,
Community Support Team _ Ailsa Tao

 

Comments
Anonymous
Not applicable

I get this in PBI Service (decimal point is lost):

VitalijaM_0-1667831518320.png

 

v-yetao1-msft
Community Support
Status changed to: Investigating

Hi @Anonymous 

I tested it in my Desktop and Service , there is no problem as you said. You can confirm if there is a problem with my steps? My test versions are Version: 2.110.805.0 64-bit (October 2022) and 13.0.19403.8 .

Recording 2022-11-08 at 14.06.40.gif

 

Best Regards,
Community Support Team _ Ailsa Tao

 

Anonymous
Not applicable

Hi @v-yetao1-msft!

 

Thanks for looking into it.

Our PBI versions match. 

 

Here, in your example I see a Legend being used and that decimal point is set on a field.

 

In my example I have whole numbers in my field, but in the chart, in the Total labels I want to see it in a Billions unit with 1 decimal point. Not to see 1bn in every Total label, but 0,4bn, 0,5bn and 0,6bn (example below).

 

I see that this miss match in PBI Desktop and PBI Service happens when I use SSAS Cube as a source.

 

PBI Desktop:

VitalijaM_0-1667893727454.png

PBI Service:

VitalijaM_1-1667893873122.png

Column chart settings when I check in PBI Service after publishing:

VitalijaM_2-1667893975431.png

After hovering:

VitalijaM_3-1667894010622.png

 

And it is unresponsive when I change decimal places value directly in PBI Service.