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.
Solved! Go to Solution.
Hi amitchandak, I could not achieve the result I was after in DAX. So instead I used Bookmarks to create two separate versions of the cards, one with the $ measure, and one for the whole number measure. Then added a toggle button to switch between the two bookmarks. Not ideal, but it works for now.
Hi amitchandak,
I have been trying to get my head around this, but when trying to add in the FORMAT command into my SWITCH statement, I am not getting the results I am after. All I want to achieve is to display the $ symbol if I toggle the selector to "$", and the other value will be a General Number without any prefixes.
I don't want to create any additional tables.
I forgot to mention that in my version of PowerBI Desktop, the "Field parameters" in the "Options" is not available. So I will need a DAX method, if possible.
Can you help me to structure my SWITCH statement to add in the FORMAT?
Thank you
Hi amitchandak, Thanks for your reply. I will have a play with links you have provided and let you know how I go!
@Deevo_ ,Create measure selector using Field Parameters
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Hi amitchandak, I could not achieve the result I was after in DAX. So instead I used Bookmarks to create two separate versions of the cards, one with the $ measure, and one for the whole number measure. Then added a toggle button to switch between the two bookmarks. Not ideal, but it works for now.
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |