Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 li...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-xicai 

Any update on this?

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

 

Regards

ROGI's avatar
ROGI
Regular Visitor
6 years ago

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