Forum Discussion

skolb0909's avatar
skolb0909
Regular Visitor
9 years ago
Solved

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 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?

  • MalS's avatar
    MalS
    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

  • Baskar's avatar
    Baskar
    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

5 Replies

  • MalS's avatar
    MalS
    Resolver III
    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

       

       

      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.

      • jestevez's avatar
        jestevez
        Advocate I
        9 years ago

        You have to format the measure like ROUND(measure;2)

         

        Example

         

  • Baskar's avatar
    Baskar
    Resident Rockstar
    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's avatar
    Hussein_Gamal
    New Member
    2 years ago
    1. Click on the column for which you need to set the value to decimal with a fixed number, not "Auto."
    2. Click on "Column Tools" in the app bar.
    3. Under the "Formatting" category, change "Auto" to a fixed number, for example, "2."