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.
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.
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.
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?
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" )
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.