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 for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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,028 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,002 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,003 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,022 Views

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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

View All