cancel
Showing results for 
Search instead for 
Did you mean: 
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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.