power bi couldn't display visual: MdxScript (Model) (135, 17) Calculation error....

[shoaibalvi]

lHi!

I have created a report which contains source data (which can be changed depending on which market we want to report on) and one "Currency table" embedded within Power BI desktop. By embedded, I mean this table is not linked to any underlying excel workbook but is created within Power BI itself.

This table is basically comprised of two columns - first column contains Currency short code like GBP, USD etc, and the adjacent column contains the currency symbol.

There is a relationship defined between the two tables and I have setup dynamic formatting so depending on what currency code is present in the source data's "Currency" column, all values presented in the report pick up the corresponding currency symbol.

Now this has worked fine for me so far. But recently, I loaded source data which contained TRY currency, with symbol "₺".

I think its this symbol causing this error to pop up, keeping certain visuals from refreshing. In the visuals which do end up refreshing, I get a completely random symbol instead of ₺. I am not quite sure whats going wrong or if there is a way to fix this? Anyone has any ideas?

[Anonymous]

Hi, @shoaibalvi 

Based on your description of the details of the problem you are experiencing with the Power BI visual display. You can try the following to resolve your issue.

1. Make sure that the TRY currency symbol is entered correctly in the currency table. It must exactly match the symbol for the Turkish Lira (₺).
2. Double-check the relationship between the source data and the currency table. Ensure that the relationship is defined correctly to ensure proper dynamic formatting.
3. ensure that your Power BI Desktop is updated to the latest version.

We will analyze and submit this problem; please be patient and we will notify you as soon as we have the latest news

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[shoaibalvi]

Hello @Anonymous! Thanks a lot for your response!

I tried the solutions and found that in the data source file, there was one rogue row right at the end which contained total, and no value in the "Currency" column. I think Power BI was interpreting this as a data row and throwing up the error because it was reading the "currency" column as having 2 difference values instead of one unique "TRY" value (because of the "blank" value in the end).

I deleted this row and it seemed to have fixed the problem - somewhat.

My visuals now update alright. However, instead of the actual lira symbol, another odd symbol "₼" is displayed everywhere.

I when into edit query for the "Currency Table" and noted that the correct lira symbol ₺ appears there just fine. Its just the main report it gets replaced by this funny symbol.

I am thinking its got something to do with character codec perhaps but i am not sure how to work around this one.

Regards,

Shoaib