Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hello all, I am facing similar issue . Please guide if anyone has solution to this
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
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.
Thanks,
Saad
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 ,
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.
Hello @v-xicai ,
All the solutions that you have share will work for tables.
But those are not working with Graphs.
Regards,
Saad