Forum Discussion
skolb0909
9 years agoRegular Visitor
kpi indicator
I'm using the KPI Indicator and having issues with rounding. In my data set for the current month I have 3 values it should sum together. They are 2.21, 1.55 and .17 which sum to 3.93. I have doub...
- 9 years ago
That's probably just a typical floating point arithmetic error. (You can read all about that here.)
To get around your problem though, how about just formatting the number so it doesn't show the decimals?
Try this:
1. Click on the KPI visualization
2. Click on the Format tab (looks like a paint roller)
3. Expand the indicator field
4. Set Decimal to 2
- 9 years ago
Cool my dear friend,
We can fix this in two different way.
Way 1:
It is permenant for the measure.
Way2:
ONly for that particular visuals
Note :
Your Problem is some arthimatic Problem i think so.
or check in your original source what is the exact value.Lte me know if any help on DAX
Hussein_Gamal
2 years agoNew Member
- Click on the column for which you need to set the value to decimal with a fixed number, not "Auto."
- Click on "Column Tools" in the app bar.
- Under the "Formatting" category, change "Auto" to a fixed number, for example, "2."