cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ubo-Pakes Frequent Visitor
Frequent Visitor

matrix, conditional formatting and format painter issues

I am having a matrix with indicators for which I now have the correct design andbackground colors, using conditional formatting (thanks @Mariusz). However, since we use 17 indicators, I have to repeat the coloring process 16 more times and this is a huge amount of clicks and typing of colornumbers (one way or another the recently used colors are also not saved 😞 ). I want to use the format painter for this as was pointed out in another post. However, this does not seem to do anything for me.

 

This is the matrix I have and from which I want to copy the settings to another one:

Capture.PNG

 

 

However, after selecting the visual, clicking the format painter icon and clicking again in a new visual, the results are not what I was hoping to see: 

 

Capture.PNG

Any ideas anyone?

 

Ubo

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
mussaenda Senior Member
Senior Member

Re: matrix, conditional formatting and format painter issues

Ah, yes. I thought you want two identical tables.

If you will change the fields, definitely the conditional formatting will be gone.

Because when you are putting the conditional formatting, it is only intended for your selected field.

I have done also the same thing with you by putting the conditional formatting to several fields repeatedly.

 

Or, you may put up a formula using switch like this in a calculated column:

Switch = SWITCH(
            TRUE(), 
           Table Name[ColumnName1] = "CHEQUE", "#80e3e3",
            Table Name[ColumnName1] = "LC", "#45e997",
           Table Name[ColumnName2] = "100284", "#97e945",
           Table Name[ColumnName3] = 0, "#3e3e3e")

"#80e3e3" - this is a hex color that you will assign. Depends on what color you need.

then

On the conditional formatting, choose field value and the column you made:

2019_10_09_09_47_22_.png

for me I m using Last as summarization. You can also try First or depends on our needed result.

 

This is the workaround I know.

Hope this helps you.

 

You may suggest an idea or maybe others have a workaround for this.

Have a nice day.

 

 

View solution in original post

6 REPLIES 6
Nathaniel_C Super Contributor
Super Contributor

Re: matrix, conditional formatting and format painter issues

@Ubo-Pakes ,

The format painter seems to work fine on copying the format, say for the Total row, but does not seem to copy the conditional formatting.

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

mussaenda Senior Member
Senior Member

Re: matrix, conditional formatting and format painter issues

Hi @Ubo-Pakes ,

 

Why not copy the visual itself?

Ubo-Pakes Frequent Visitor
Frequent Visitor

Re: matrix, conditional formatting and format painter issues

Thanks for the suggestion. Tried it, but then I have to change the fields and field names and that seems also to get rid of the conditional formatting ... 

 

Ubo

Highlighted
mussaenda Senior Member
Senior Member

Re: matrix, conditional formatting and format painter issues

Ah, yes. I thought you want two identical tables.

If you will change the fields, definitely the conditional formatting will be gone.

Because when you are putting the conditional formatting, it is only intended for your selected field.

I have done also the same thing with you by putting the conditional formatting to several fields repeatedly.

 

Or, you may put up a formula using switch like this in a calculated column:

Switch = SWITCH(
            TRUE(), 
           Table Name[ColumnName1] = "CHEQUE", "#80e3e3",
            Table Name[ColumnName1] = "LC", "#45e997",
           Table Name[ColumnName2] = "100284", "#97e945",
           Table Name[ColumnName3] = 0, "#3e3e3e")

"#80e3e3" - this is a hex color that you will assign. Depends on what color you need.

then

On the conditional formatting, choose field value and the column you made:

2019_10_09_09_47_22_.png

for me I m using Last as summarization. You can also try First or depends on our needed result.

 

This is the workaround I know.

Hope this helps you.

 

You may suggest an idea or maybe others have a workaround for this.

Have a nice day.

 

 

View solution in original post

Ubo-Pakes Frequent Visitor
Frequent Visitor

Re: matrix, conditional formatting and format painter issues

Thanks a lot. Will give this a try!

 

Ubo

Ubo-Pakes Frequent Visitor
Frequent Visitor

Re: matrix, conditional formatting and format painter issues

@mussaenda Thanks! Works great and you are saving me a huge amount of time!

 

Ubo

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)