Forum Discussion

jatejedor's avatar
jatejedor
New Member
9 years ago
Solved

Issue with decimal and thousands separator. Tried everything.

Hi

I have read everything on forums about this problem but the solutions don't work for me.

I'm writing from Spain. We use "." as thousands separator and "," for decimals.

This report should show about 19 hours on this colum.

I already changed column format and it appears ok on the data visualization.

 

I "refreshed" data.

 

I also changed regional settings on Power BI to USA.

 

The report is still showing wrong values.

 

Any idea?

Need Help
  • Salvador's avatar
    Salvador
    9 years ago

    Hello,

     

    I'm Spanish, and had the same issue.

     

    Instead of changing the computer's regional settings, what I did was changes in the pbix file options, as shown on the screenshots

     

     

     

     

     

5 Replies

  • Salvador's avatar
    Salvador
    Icon for Responsive Resident rankResponsive Resident
    9 years ago

    Hello,

     

    I'm Spanish, and had the same issue.

     

    Instead of changing the computer's regional settings, what I did was changes in the pbix file options, as shown on the screenshots

     

     

     

     

     

    • jatejedor's avatar
      jatejedor
      New Member
      9 years ago

      Now I can see the numbers in in the right format.

      but loot at the first two rows. The sum is 14,5.

      If I use the sum function I get this: 54,5

      Any idea?

      • Salvador's avatar
        Salvador
        Icon for Responsive Resident rankResponsive Resident
        9 years ago

        Hello,

         

        hmmm could you add a screenshot from the data view, modeling? 

         

         

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi jatejedor,

     

    Did you try to change the formats in the local computer as the picture showed (in the Control panel)? Maybe this is what you want.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale