Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 double and tripple checked my data source and there are no extra decimal places. The KPI Indicator shows 3.929999999997 and I have no idea why. I have the Actual Value set as sum.
I see no way to set any rounding for the Actual Value. Can anyone help me solve this mystery?
Solved! Go to Solution.
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
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
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
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
Any one else not seeing option to format this KPI value for this visualization ? Seems like a bug to me, as I've got the measure formatted as desired.
You have to format the measure like ROUND(measure;2)