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: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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,087 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,061 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,062 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,081 Views

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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