Switching Currency type dynamically keeping formatting.

[Anonymous]

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 the currency symbol ($, € and £) in both data label and in Y- Axis.

I try using FORMAT DAX, the currency symbol in Y-Axis just disappears.

I want to avoid using Bookmark for this.

Below is the link to PBIX file.
https://we.tl/t-by9y8UWa8Z

[Anonymous]

Hello all, I am facing similar issue . Please guide if anyone has solution to this 

[amitchandak]

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]

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]

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]

Hello @v-xicai ,

All the solutions that you have share will work for tables.

But those are not working with Graphs.

Regards,

Saad