Difference between counting decimal numbers in desktop or webviewer.

[Lucvdg]

I have a problem with this PowerBI report:

When I work in the desktop editor the numbers are shown correct, but in the viewer it becomes incorrectly:

Desktop editor:	Webviewer:

The problem happens apparently between the comma and dot.

Because in the example below you can see that PowerBI counts the 0.9 as 9.

In the desktop editor I know you can change it from decimal to integer, but is there also a similar setting for in the web viewer?

Or do I need to search for a solution in a totally different angle?

Thanks in advance!

[Lucvdg · Accepted solution]

I had the same data also in another column and when I referenced to that in my formulas everything worked how it should. 

To bad that I dont know why this worked, since it was the same data in the same format.
But still.

[Lucvdg]

Can you further explain?
Because for me its hard to understand it.

And I really think it counts the numbers behind the comma.

In any situation it adds up.

See example (55 + 6 + 6 + 6 and many one's = exactly 95 FTE)

So something with filters would not apply with this right?

[Kishore_KVN]

Hello @Lucvdg , 

there wont be such kind of difference between desktop and web viewer. In desktop you might have applied filters or selected any category in slicer but in service you may not have selected any specific value like that. Please check with slicers and filters and if problem still exits let us know. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!