Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
KBUIUS
Helper I
Helper I

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 things at row-level like in Excel, ie. this row it's $ amount, next row it's Count, next row is % (users want to see the sign)

 

Any suggestion to achieve that? please

1 ACCEPTED SOLUTION
serpiva64
Super User
Super User

you can try something like this (look only the format)

Column = if(dimProduct[WeightUnitMeasureID]="grams"FORMAT(dimProduct[Weight],"Fixed"), FORMAT(dimProduct[Weight]/100,"Percent"))

serpiva64_0-1648833287848.png

 

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 !

View solution in original post

3 REPLIES 3
serpiva64
Super User
Super User

you can try something like this (look only the format)

Column = if(dimProduct[WeightUnitMeasureID]="grams"FORMAT(dimProduct[Weight],"Fixed"), FORMAT(dimProduct[Weight]/100,"Percent"))

serpiva64_0-1648833287848.png

 

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 !

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 &"%".

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.

KBUIUS_1-1648844141146.png

 

Here is the data

KBUIUS_2-1648844231492.png

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors