Forum Discussion
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---Col...
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.