Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
my need is to color 2 cells of the same column if they have the same value; for example:
REF | COLORTHAT |
ABC | THISYES |
DEF | THISNO |
GHI | THISYES |
thanks
Solved! Go to Solution.
Hi @Mikahel369 ,
According to your description, here's my solution.
Create a measure.
Color =
IF (
COUNTROWS (
FILTER ( ALL ( 'Table' ), 'Table'[COLORTHAT] = MAX ( 'Table'[COLORTHAT] ) )
) > 1,
"Red"
)
In the visualizations pane, select the drop-box of COLORTHAT, then click Conditional formatting>Font color.
Select the measure in the dialog.
Get the expected result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can use this formula in conditional fomatting.
Select first the range in which you want to apply the conditional formatting (in my case C3:C6)
Go to the HOME --> Conditional formatting --> New rules --> "Use formula ..:".
Paste this formula to the box--> =IF(COUNTIF($C$3:$C$6;C3)>1;TRUE;FALSE)
Click FORMAT and adjust the formatting and then press OK.
If it doesn't work get back and remove from the formula the double quotes.
✅ Check the question as solved if I helped you.
You can follow me on LinkedIn:
Hi @Mikahel369 ,
According to your description, here's my solution.
Create a measure.
Color =
IF (
COUNTROWS (
FILTER ( ALL ( 'Table' ), 'Table'[COLORTHAT] = MAX ( 'Table'[COLORTHAT] ) )
) > 1,
"Red"
)
In the visualizations pane, select the drop-box of COLORTHAT, then click Conditional formatting>Font color.
Select the measure in the dialog.
Get the expected result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'll move elsewhere... if I found how to