-1

I'm creating some reports in Power BI. The data is stored on a SQL server and contains a Unit column with different units consisting of text and/or symbols. I have a problem with the £ sign, which is being converted by Power BI into a #.

How do I get Power BI to stop doing this? I can't see anything in the settings allowing me to change to UK English.

I'm getting around this by using Power Query to replace the # with a £. I could create a new column and use a substitute formula, but either solution isn't ideal in the long term, because 1/ the hashtag may be used for something else in the future and 2/ data comes from multiple sources and it will require additional work to ensure that the correct text is used in the report.

user2632074
  • 11
  • 1
  • 6

1 Answers1

0

Go to data view in powerbi desktop.

enter image description here

Select the column you need to add currency. And from the above tabs click your currency.

enter image description here

enter image description here

Mr Robot
  • 307
  • 2
  • 12
  • I have something slightly different. The format is set to Text and I can't change it through the drop down. The rest is greyed out and unavailable. – user2632074 Sep 27 '21 at 12:15
  • So you're saying your column is not currency, it's a single char? No Numbers? Because if it is currency you choose currency and then in the data model set a format string. If it's only text, but a weird character, verify you are using the right encoding. SQL can have different collations per server, per table, – ninMonkey Oct 04 '21 at 15:21