Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |