Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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:
Any ideas anyone?
Ubo
Solved! Go to Solution.
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:
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.
Hi @Anonymous ,
Why not copy the visual itself?
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
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:
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.
Thanks a lot. Will give this a try!
Ubo
@Anonymous ,
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |