Forum Discussion
Conditional formatting - copy and paste
Hi Anonymous ,
You can implement your demand following steps below.
- Select the visual that already has the desired formatting options settings.
- Click the “Format Painter” button under the Home
- 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.
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
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.
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!
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
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)....
thanks, works like a charm!
