Forum Discussion
How to compare text in many columns with a reference column
Hi
I have 100s of equipment configuration files which I've managed to get into the below matrix (super excited)
Is it possible to compare each of these text columns with a reference column? And change colour if different?
Example below- text values that do not match the green columns are highlighted red?
Hope that makes sense- I'm new to PowerBI
Thanks
Gary
Hi GaryDC ,
Please use conditional formatting -> background color
Result:
Pbix in the end you can refer.Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- v-chenwuz-msft
Community Support
Hi GaryDC ,
Please use conditional formatting -> background color
Result:
Pbix in the end you can refer.Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- GaryDCFrequent Visitor