Forum Discussion

satyaraj's avatar
satyaraj
Frequent Visitor
6 years ago
Solved

Currency Symbols Not Showing

Hello Team, I’m using a switch condition to switch to different colums which are values in different currencies using filter. I already have columns of different currencies with exchanged values, ...
Need Help
Show and Tell
Tips and Tricks
  • satyaraj's avatar
    satyaraj
    6 years ago

    Hello, thank you for taking out time and giving a reply,

    This we already tried but just want to know if the currency symbol appears with the value. Is there any possibility in DAX so that I can display the values with the currency symbol in all the visualizations? since I have many other categories, I don't want to use currency as a category.

    I found using a bookmark would be a feasible solution wherein I can select each currency on a page and linking it to a button. It has its disadvantages like memory and dynamically data will not update into those bookmarked pages (if I’m not wrong).
    So, kindly let me know if we have any other solution for this.

satyaraj's avatar
satyaraj
Frequent Visitor
6 years ago

Thanks for replying,

The problem with DAX FORMAT is we are not able to use that measure in any visualizations except table.

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi satyaraj, 

To show currency symbol in chart and table, one workaround is that you culd create a column for symbols. You could refer to my sample for details.

Best Regards,
Zoe Zhi

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

 

  • satyaraj's avatar
    satyaraj
    Frequent Visitor
    6 years ago

    Hello, thank you for taking out time and giving a reply,

    This we already tried but just want to know if the currency symbol appears with the value. Is there any possibility in DAX so that I can display the values with the currency symbol in all the visualizations? since I have many other categories, I don't want to use currency as a category.

    I found using a bookmark would be a feasible solution wherein I can select each currency on a page and linking it to a button. It has its disadvantages like memory and dynamically data will not update into those bookmarked pages (if I’m not wrong).
    So, kindly let me know if we have any other solution for this.

    • dax's avatar
      dax
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi satyaraj,

      Thank you for sharing your solution, currently, there is no method to change  currency synbol in DAX measure. So I think you might need to use bookmark currently. In addition, you also could post this requirement on power-bi-ideas .

       

      Thanks for your understanding and support.
      Best Regards,
      Zoe Zhi

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