Forum Discussion
Solved
Power BI doesn't use decimals
Hi, Been trying all afternoon to get a dashboard together. Problem is that when I upload data with amounts like 2.5 & 3.6, the dasboard adds these up in a graph/table etc. as 2 + 3 = 5 instead ...
Never mind,
In the edit query I found that in the "applied steps" window i made 2 (historic) alterations for the data, first I made it a "whole numer" then a couple steps later a "decimal"....deleted the first step and the data came through ok.Solved, -1 kudo for meself!
thanx for the input though!
Have you checked to make sure that the column's data type and formatting match the decimal output you want? Depending on exactly what you're trying to do you may also want to create a measure, even if it's a simple Total Thing = SUM(Table[Thing]) so that you can set the number type, formatting, number of decimal places, etc on the measure itself.