Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone! I am trying to create a measure that dynamically changes the currency symbol depending on the country selected in a slicer. It looks a bit like this at the moment:
IF(SelectedCountry=1,"£"&Price,"$"&Price)
The problem with this is the number has lots and lots of decimal places, and ideally I just want it to show a whole number with the correct currency symbol, so rather than £16.1828490230 it would show £16.
Is this possible?
Solved! Go to Solution.
Hi @badger123
In the place of Price, pls use INT( [Price] ). This will truncate the decimal part.
Thanks
Raj
Hi @badger123 ,
Change your measure to:
IF(SelectedCountry=1,Format([Price],"0£"),Format([Price];"0$"))
If you want to have decimal places make it like this
IF(SelectedCountry=1,Format([Price],"0.00£"),Format([Price];"0.00$"))
Be aware that instead of dot on the decimals can be comma depending on your regional settings.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @badger123
In the place of Price, pls use INT( [Price] ). This will truncate the decimal part.
Thanks
Raj
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |