Comparing 2 datasets and highlight cells with differences

[yagmai]

Hi all,

I have Table1 and Table2 which have key rows of 30000+. There are 200 columns.

Table1

-------Col1---Col2---ColN

R1       1            1  

R2

R300   1

Table2

-------Col1---Col2---ColN

R1       1            1  

R2       1

R300   1

how do I highlight cell in yellow that has differences (eg: Col1R2 ) ?

Thanks in advance

[v-jingzhang]

Hi @yagmai 

Power Query doesn't have any color formatting. Where do you want to highlight the cells? Do you have these data in Excel workbooks and hope to highlight the cells in yellow in Excel? If so, Power Query doesn't support that. 

If you want to create a Power BI report which has a table visual that displays all these data and highlights the different cells, I'm afraid this is not possible either as there are too many data points in one table visual and there are too many columns for color formatting. 

Both Power Query and Power BI are not suitable tools for this requirement. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.