Forum Discussion
Solved
Column format
I know powerbi treat everything in a column in a consistent format, like everything has to be either $ or time/date or whole number. But for displaying purpose, I have a need to customize thing...
you can try something like this (look only the format)
Column = if(dimProduct[WeightUnitMeasureID]="grams", FORMAT(dimProduct[Weight],"Fixed"), FORMAT(dimProduct[Weight]/100,"Percent"))If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
you can try something like this (look only the format)
Column = if(dimProduct[WeightUnitMeasureID]="grams", FORMAT(dimProduct[Weight],"Fixed"), FORMAT(dimProduct[Weight]/100,"Percent"))
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
I try to use it but it doesnt work. I am using a table since Matrix is aggregating everything.
Look at the Test1 measure, even it's Currency or percent it doesnt work.
Here is the data
My bad, I format that column 4Q PR as text, because there are text in the first row of the column.
So I play with it as text : "$" & value or value &"%".
