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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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.