Forum Discussion

Anonymous

Not applicable

6 years ago

Switching Currency type dynamically keeping formatting.

Hello, I have 3 graph, showing result base on currency type. (EURO, GBP and USD). Is there any way to just keep one graph and switch the currency dynamically using slicer? Please note:- I need ...

Super User

6 years ago

Have you explored this

http://www.kpipartners.com/blog/dynamic-selection-of-measures-in-power-bi

https://community.powerbi.com/t5/Desktop/Cannot-use-measure-in-slicer/td-p/166909

Anonymous
Not applicable
6 years ago
Hello amitchandak

I am able to switch currency values by using slicer.
Where I am struggling is that I am not able to get currency icon dynamically in datalable and Y-Axis for BAR GRAPH. Is there any way to achieve this?
Please refer below screenshot and PBIX file.

PBIX file is uploaded in below link.
https://we.tl/t-3SYmKv4UfA

Thanks,
Saad
- v-xicai
  Community Support
  6 years ago
  Hi Anonymous ,
  
  You can refer to the similar cases:
  
  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
    Not applicable
    6 years ago
    Hello v-xicai ,
    
    All the solutions that you have share will work for tables.
    But those are not working with Graphs.
    
    Regards,
    Saad