Currency custom format cells in Excel to Power BI

[Anonymous]

Good afternoon,

In Excel I have a report from SAP that gives me differents currency on the same collumn. Since they stay with custom cell format, when I put the file in Power BI it doesn´t give me the currency only the values.

Example:

Excel:

1131564 USD

1254654 USD

5465456 EUR

57657467 EUR

5464 GBP

5644454 GBP

Power BI:

1131564

1254654

5465456

57657467

5464

5644454

There´s any way that Power BI can show me the currency the same way that excel does ?

Best regards

Ricardo Silva

[v-xicai]

Hi @Anonymous ,

Currently, it is unavailable to recognize the currency unit in Power BI Desktop.

If you need to remain the original data format, you may convert the data to Text data type. Or you may click on this column in Excel, go to Data-> Text to Columns ->Delimited ->Space ->Finish, to split this currency column into two separated column like picture below, rename these columns.

Then you can connect the excel file, put then currency column into Slicer visual to filter different currency data.

You can refer to these cases to learn how to apply the currency slicer in formulas:

https://community.powerbi.com/t5/Desktop/Control-which-currency-is-displayed-with-slicer/td-p/60055 ,

https://community.powerbi.com/t5/Desktop/How-To-Unify-the-Report-Currency-Based-On-the-Slicer/td-p/310782,

https://community.powerbi.com/t5/Desktop/Exchange-rate-parameters-to-use-as-slicer-in-report/td-p/884632

Best Regards,

Amy

Community Support Team _ Amy

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

[Anonymous]

Hello,
 
That didn´t work, because my problam it´s that all the currency cell are with custom format amout + the type of currency. So when I enter the cell only shows me the amout.

https://imgur.com/Wab4TOY 

https://imgur.com/kzUH9ao

[Anonymous]

Anyone got some type of work around for this?

[v-xicai]

Hi @Anonymous ,

About how to apply the Currency column, you may refer to the links shared above.

Best Regards,

Amy

Community Support Team _ Amy

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

[Greg_Deckler]

What does the source data look like? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490