cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vmakhija
Post Prodigy
Post Prodigy

Conditional formatting - copy and paste

Hello

Is there a way to copy & paste conditional formatting in the matrix visual? Like do a format painter for conditional formatting from 1 Values field to another? or some other way out? I have like 30-35 fields where I need to do same kind of conditional formatting.

 

Regards

11 REPLIES 11
woony
Frequent Visitor

Also looking for a solution.

When having a large table with a lot of columns with same types of values, or even booleans, it is very time consuming to copy this to all columns...

Quakker
New Member

Still looking for a Solution. Really time consuming to enter the Same rules for a lot of measures within the same table...

Earosenfeld
Advocate II
Advocate II

Still an Issue, please fix this PowerBi. 

same here. This is a huge waste of time and super expensive if an powerbi expert is working on that. 

v-xicai
Community Support
Community Support

Hi @vmakhija ,

 

You can implement your demand following steps below.

 

  1. Select the visual that already has the desired formatting options settings.
  2. Click the “Format Painter” button under the Home
  3. Click the visual which you’d like to assign the same formatting options.

 

Best Regards,

Amy

 

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

@v-xicai 

Any update on this?

This will really save time for reports where we heavily use matrix and tables.

 

Regards

ROGI
Regular Visitor

Now you can set a value field in the conditional formatting options.

 

Just create a measure with the rules and conditions in DAX and assign it to each field.

 

Revenue KPI Color = SWITCH(
     TRUE()
     ,SUM('Sales'[Revenue]) < 50000000, "#f44242"
     ,SUM('Sales'[Revenue]) < 1000000000, "#f4f142"
     ,SUM('Sales'[Revenue]) > 1000000000, "#5ff442",
     "#f44242"
)

 

Source

https://www.blue-granite.com/blog/controlling-conditional-formatting-using-dax

Hi there, perhaps I am doing something wrong but when I try and copy the colouring choices in the Conditional Formatting from one Matrix visual to another it doesn't do anything for me. Please advise what I am missing?

 

Thanks..........Steve

@v-xicai 

Actually, I don't want to copy the formatting from one visual to another.

Rather, I need to do it within the same visual -> from one value field to another.

 

Regards

I'm having the same problem.

A solution would be highly appreciated

Same issue here.. Looking for a solution for this! 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors