Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |