Forum Discussion

b-kopik's avatar
b-kopik
Helper III
1 month ago
Solved

Number formatting in dashboard

Hello,

 

Does anyone know how to fix this? I am not sure why I am getting 1.1000000001 in my dataset? I checked the backend data and it is all 1.1 etc I copied and pasted special, replaced the fields and not sure what else to do:

 

 

 

Thanks!

Bruna

Need Help
  • Rupa01's avatar
    Rupa01
    1 month ago

    b-kopik check out below example - 

    Before - 

     

    After Rounding - Right click column > Transform > Round > Round.. > Add 1 in Decimal Places

     

    💡 Helpful? Give a Kudos 👍 — keep the community growing
    ✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

    Best regards,
    Rupasree Achari | BI & Fabric Analytics Engineer

5 Replies

  • Rupa01's avatar
    Rupa01
    Solution Sage
    1 month ago

    Hi b-kopik,

    Currently, the data type of the column is decimal.

    If you want to have upto 1 decimal point, then keeping the column data type as "Decimal" choose below option to round upto 1 decimal.

     

    💡 Helpful? Give a Kudos 👍 — keep the community growing
    ✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

    Best regards,
    Rupasree Achari | BI & Fabric Analytics Engineer 
    • Rupa01's avatar
      Rupa01
      Solution Sage
      1 month ago

      b-kopik check out below example - 

      Before - 

       

      After Rounding - Right click column > Transform > Round > Round.. > Add 1 in Decimal Places

       

      💡 Helpful? Give a Kudos 👍 — keep the community growing
      ✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

      Best regards,
      Rupasree Achari | BI & Fabric Analytics Engineer
    • b-kopik's avatar
      b-kopik
      Helper III
      1 month ago

      Thanks! Unfortunately I have some fields that say 'not available' so I can't convert to a number

      • Rupa01's avatar
        Rupa01
        Solution Sage
        1 month ago

        b-kopik checkout below power query sample code that will transform the text column with decimal values upto 1 decimal places - 

        let
    Source = XXXXXXX,
    #"test"=
    Table.TransformColumns(
        Source,
            {
                "Column1", 
                each try Number.ToText(Number.Round(Number.FromText(_), 1), "0.0") 
                otherwise _, type text
            }
    )

in
    #"test"

        Example - 

        Before - 

        After - 

         

        💡 Helpful? Give a Kudos 👍 — keep the community growing
        ✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

        Best regards,
        Rupasree Achari | BI & Fabric Analytics Engineer