Forum Discussion
hmokkapati
Helper II
Helper IIChange DAX measure format based on Market selection
Hello, I have the below sample data model with different countries and Prices in those countries in the same table. We are not planning to do the Currency Conversion, but display th...
That is surely most elegant solution for now. Cheers!
parry2k
Super User
Super UserGoto modelling tab and change it to number format (Whole number etc)
hmokkapatiHello parry2K
It wouldn't let me because of the way the Measure is written it treats it as "Text. The other options are disabled to choose.
The requirement is to be able to change the format of the measure to different currencies based on the country selected in the slicers.
Thank You,
Harisha
- parry2k
Quick question, seems odd but do you want chart to show mixed currencies?
- hmokkapati
Sorry forgot to mention, User would select only one Market at a time.