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: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
swragg
Helper I
Helper I

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
817 Views
0
1 ACCEPTED SOLUTION
v-alq-msft
Community Support
Community Support

‎04-09-2020 09:21 PM

Hi, @swragg 

 

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
791 Views
2 REPLIES 2
v-alq-msft
Community Support
Community Support

‎04-09-2020 09:21 PM

Hi, @swragg 

 

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
792 Views
parry2k
Super User
Super User

‎04-09-2020 05:00 PM

@swragg, 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
811 Views

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All