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.
I have a line chart that I am using a switch statement to select two different groups of measures. One is a whole number and the other is in currency.
Is there a way to have the chart automatically change to currency when a measure is selected that should be in currency and switch back?
Here's my measure.
Select =
IF (
HASONEVALUE ( _Daily[Sort] ),
SWITCH ( VALUES ( _Daily[Sort] ), 1, ( [Orders $] ), 2, [Orders #] )
)
Format cannot be changed in a DAX measure. But you may drag both measures to Values and let one of the two return BLANK () based on the selection.
Would you mind explaining a bit more what you mean by this? How do I make one of the two measures return blank(), when the other is selected?
Use the FORMAT() function like this
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I tried this, but I can't figure out how to make it show in the line chart visual. It won't even allow me to move the measure to the Values.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |