cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

comma-separated decimals lost in service but working in Power BI desktop

Hello,

 

I'm using an MS SQL server as  datasource. From this server I load a column formatted as text in which I have "real" text, numeric entries (decimal) and empty cells. Only the numbers are what I want to display in a chart, so I remove the empty cells and the text values by the following steps in the query editor:

 

= Table.TransformColumnTypes(#"Expanded mytable",{{"MyColumn", type number}})
= Table.RemoveRowsWithErrors(#"Changed Type1", {"MyColumn"})

 

Now the problem starts, I see the column exactly as I need it formatted as decimal numbers and in Power BI Desktop everything works fine. However as soon as I publish the report to the service and refresh my dataset once through the gateway, the commas that I use as separators are lost - so 0,25 turns into 25 and 6,5 turns into 65 in my visualization.

 

If tried changing the locale type of my column like

 

= Table.TransformColumnTypes(#"Changed Type", {{"MyColumn", type number}}, "de-AT")

 

Other things that I tried was adding a new column in which I did the tranformations and changing the locale, everything without success. I guess the service just doesn't seem to realize that I use comma-separted decimals.  

 

Does anyone have an idea what I can do? In the rest of the same report as well as all other reports everything works and I've not encountered the problem anywhere else, without messing around with locale format at all.

1 REPLY 1
Microsoft
Microsoft

Hi @tswest ,

 

You can probably refer to the similar solved post for reference:http://schoennie.blogspot.com/2018/11/thousand-separator-and-decimal.html 

 

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors