Forum Discussion

sublog's avatar
sublog
Icon for Helper III rankHelper III
6 years ago

Dynamically change measure's format in visual (line chart) using switch?

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 automatica...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
6 years ago

sublog 

 

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.

Quiny_Harl's avatar
Quiny_Harl
Icon for Advocate III rankAdvocate III
5 years ago

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?