Forum Discussion

yagmai's avatar
yagmai
New Member
3 years ago

Comparing 2 datasets and highlight cells with differences

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

Need Help
Show and Tell

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    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.