Forum Discussion

leolapa's avatar
leolapa
Frequent Visitor
4 years ago
Solved

Power BI not taking manually inputted decimal places

I was trying to create a new calculated column using DAX, and when I tried to use a hardcoded number in this calculation, I realized that Power BI will simply ignore the "dot" decimals separator and ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi leolapa ,

     

    On my side, windows region and region settings in Power BI Desktop are United States:

    So you may go to the Additional settings to manually change the format as the first screenshot shown, or change the region settings in PBI  from "Windows default" to United States:

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi leolapa ,

 

On my side, windows region and region settings in Power BI Desktop are United States:

So you may go to the Additional settings to manually change the format as the first screenshot shown, or change the region settings in PBI  from "Windows default" to United States:

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.