Forum Discussion

shoaibalvi's avatar
shoaibalvi
Icon for Helper I rankHelper I
2 years ago

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

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, ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
shoaibalvi
Icon for Helper I rankHelper I
2 years ago

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