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.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |