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.
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.
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?
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...
Hi @vmakhija ,
You can implement your demand following steps below.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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" )
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?
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.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
At the monthly call, connect with other leaders and find out how community makes your experience even better.
Click here to read more about the May 2022 updates!