cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Skilled Sharer
Skilled Sharer

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 like 30-35 fields where I need to do same kind of conditional formatting.

 

Regards

7 REPLIES 7
Highlighted
Community Support
Community Support

Re: Conditional formatting - copy and paste

Hi @vmakhija ,

 

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.

Highlighted
Skilled Sharer
Skilled Sharer

Re: Conditional formatting - copy and paste

@v-xicai 

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

Highlighted
New Member

Re: Conditional formatting - copy and paste

I'm having the same problem.

A solution would be highly appreciated

Highlighted
Advocate I
Advocate I

Re: Conditional formatting - copy and paste

Same issue here.. Looking for a solution for this! 

Highlighted
Helper I
Helper I

Re: Conditional formatting - copy and paste

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

Highlighted
Skilled Sharer
Skilled Sharer

Re: Conditional formatting - copy and paste

@v-xicai 

Any update on this?

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

 

Regards

Highlighted
Regular Visitor

Re: Conditional formatting - copy and paste

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors