Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Anonymous
Not applicable

Conditional formatting of columns: do all columns at one time

‎04-09-2020 04:42 PM

Hello,

 

I have become quite familiar wiht conditional formatting in the table.

 

Is there a way to apply the conditional format to ALL columns in the table, rather than going at it one by one? I have over 20 columns....

 

Thank you.

Labels:
Message 1 of 3
1,092 Views
0
1 ACCEPTED SOLUTION
v-alq-msft
Community Support
Community Support

‎04-09-2020 09:21 PM

Hi, @Anonymous 

 

It is unsupported to do conditional formatting on all columns at one time. You may refer the official document . Do pay attention to the limitations and considerations. I'd like to suggest you post a new idea in Idea Forum , and add your comments there to improve Power BI for making this feature coming sooner.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Message 3 of 3
1,066 Views
2 REPLIES 2
v-alq-msft
Community Support
Community Support

‎04-09-2020 09:21 PM

Hi, @Anonymous 

 

It is unsupported to do conditional formatting on all columns at one time. You may refer the official document . Do pay attention to the limitations and considerations. I'd like to suggest you post a new idea in Idea Forum , and add your comments there to improve Power BI for making this feature coming sooner.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Message 3 of 3
1,067 Views
parry2k
Super User
Super User

‎04-09-2020 05:00 PM

@Anonymous, unfortunately, you have to go one by one.

 

Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 3
1,086 Views

Helpful resources

Announcements
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!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.

View All