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
v-xicai's avatar
v-xicai
Community Support
7 years ago

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.

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