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.
Used below DAX to format set of numbers, inorder to show percentage as percentage, number as numbers.
Solved! Go to Solution.
The FORMAT() syntax always converts the value to string. So if your aim is to make calculations it is not possible to use FORMAT().
To my knowledge you will not be able to mix percentage with number formatting while still maintaining numeric format on your column/measure.
In case anybody stumbles across this in future, you can now select "dynamic" formatting from the taskbar and use an expression to alter formatting between % and # as needed. For example:
The FORMAT() syntax always converts the value to string. So if your aim is to make calculations it is not possible to use FORMAT().
To my knowledge you will not be able to mix percentage with number formatting while still maintaining numeric format on your column/measure.
Is it possible nowadays?
Hi @vitorgps ,
To my knowledge this is still the case.
But you can always have a completly numeric measure in the backgroud that you use for calculations, while displaying the formatted one.
So if you have two formatted measures displaying both numeric and percentage formats:
Measure 1 (formatted)
Measure 2 (formatted)
You can then have copies of those, that are completly numeric:
Measure 3 (numeric)
Measure 4 (numeric)
You can then calculate a new measure 5, dependant on measure 3 & 4. Then you format measure 5 to match the formatting of 1 & 2.
Hope this helps,
J
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |