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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Conditional Formatting By Column In a Table

Please see the image shared below.  I have a table in power BI that contains two columns that need different conditional formatting.  I am ok with background colors or icons.  The DCM column conditions are different thant he DCO conditions.  Is there a way to do this?  ANy help is apprecaited, thank you.  I tried looking for other similar forum questions, could not seem to find an answer. 

 

cond_form.jpg

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi Nemanja, I hope you saw my earl;ier reply.  What you suggesteed was for a single level ability to use conditional formatting, I needed conditional formats that vary.  So the only way I coul;d work around this was to split my data up into a new table ane then do discreetly.    If you look at the first question, you see that the data is in one column.  I Had to split it out into three columns in order to do the formatting like I wanted.  Thanks, though.

Done.jpg

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Thanks for the reply, yes I understand how to do, but the problem is the columns are from one data source, not multiple as it seems your image shows.   I need different conditional formats in the two columns.  As mentioned in the first post, I want to have very different format needs for the DCM and DCO columns.  The only other way I could think of is to split out the data, but doing that becomes problematic due to the blank values (i.e., one column in the table for DCO, DCM, and RDTC).format 2.jpg

nandic
Super User
Super User

@Anonymous when dealing with conditional formatting on percentages, i use this approach:
1) select visual
2) go to fields > click on arrow beside field that you want to assign conditional formatting
3) format style = Rules
4) start from Min to Max, pay attention to <, <= to make sure you covered all ranges. Use number: 10% = 0.1, 50% = 0.5

Here is example:

nandic_0-1715811648532.png

 

Cheers,
Nemanja Andic

Anonymous
Not applicable

Hi Nemanja, I hope you saw my earl;ier reply.  What you suggesteed was for a single level ability to use conditional formatting, I needed conditional formats that vary.  So the only way I coul;d work around this was to split my data up into a new table ane then do discreetly.    If you look at the first question, you see that the data is in one column.  I Had to split it out into three columns in order to do the formatting like I wanted.  Thanks, though.

Done.jpg

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors