Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

19 REPLIES 19
MTAYLOR5
Frequent Visitor

I'm hoping this will work - I'm about to try it as have been frustrated as well on this topic!   

https://powerbi.microsoft.com/en-us/blog/power-bi-enhanced-report-format-pbir-in-power-bi-desktop-de...

Skip down to this part and read how to duplicate formats within the JSON code:

 

MTAYLOR5_0-1721079128030.png

 

Bimbam
Regular Visitor

All the workarounds in this post may situationally solve the problem.

However, the very fact users need to workaround an appalling UX flaw is NOT a solution.

To reiterate (to the clearly 0 PowerBI devs who give a **bleep**). When I have the following recently created Conditional Formatted colors:

Bimbam_0-1686122800800.png

If I now save/reopen conditional formatting and try to change one, this is what recent colours looks like:

Bimbam_1-1686122869945.png

Not only are my VERY recently declared colours not there, but there are also colours here I literally do not use in my report (which I assume are just theme defaults).


Now if I go and say change a Values Text Color font, the next time I change it I can see the update to Recent colours next time I select Text Color. But going back to Conditional Formatting rule? nada.

YemenKing
Regular Visitor

This solution worked for me.

 

1. Create a new matrix.

2. Copy paste the format (from the table with the conditional formatting) to the new matrix using Format Painter

3. Add the measure with the conditional formatting to the new matrix. The trick is to add the measure first before anything else. You will see that the conditional formatting of the initial matrix is copied. Then you can add other rows/columns.

 

I hope it helps.

 

 

Earosenfeld
Advocate II
Advocate II

There really is only one solution, try and talk with your company to transfer away from PowerBI. After using this for over 3 years I can tell you PowerBI will try their hardest to not fix these issues. 

nohowUp_fnDown
Advocate I
Advocate I

3 years later and still this isn't working? Seems like the longer I do this (over 20 years now), the software tools get worse and worse. Can we blame it on agile methods? You don't ask for it, you don't get it? Any feature not specifically requested gets removed. Anyone try Control-Z in Power BI Desktop?

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
Helper II
Helper II

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 @Anonymous ,

 

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.

thanks, works like a charm!

That seems like a solution for copying from one visual to another. What about copying to multiple columns in the same table? I think that is the original question and still unanswererd.

Anonymous
Not applicable

@v-xicai 

Any update on this?

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

 

Regards

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

Anonymous
Not applicable

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

Anonymous
Not applicable

No you did not do something wrong. I got the same problem.  It doesn't work because it only works when you try it on the same colomn(When I try it)....

Anonymous
Not applicable

@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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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