Forum Discussion
Solved
PBI only recognize % as Text type after using Dax: Format ( value, "0.0%) - Help
Used below DAX to format set of numbers, inorder to show percentage as percentage, number as numbers. Value = if([Value]<-1,[Value],if([Value]<1,FORMAT([Value],"0.0%"),[Value])) eg: ...
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: