Power BI:比较表格视觉对象中的两列

本文介绍了Power BI:比较表格视觉对象中的两列的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试比较 Power BI 中的两列，并且仅当一列与另一列存在差异时才显示颜色.

像这样:

图片来自:

I am trying to compare two columns in Power BI and only color when there is a difference from one column to another.

Like this:

The pictures are from: community.powerbi/t5/Desktop/Compare-two-columns-in-a-table-visual/m-p/272761#M122058

I saw the solution there (the link above), but since it was asked two years ago, I wanted to check if there is a better solution or color formatting I am not aware of.

I have to compare over 70 pairs of columns. That is why I was checking if there is an alternative that does not require to create a column per pair

Or how would you approach it?

I really appreciate any help you can provide.

解决方案

Conditional formatting has improved. You can now conditionally format a column by other fields. So you can define a difference measure and use that:

Diff = IF ( SUM ( Sales[Sales - DB] ) = SUM ( Sales[Sales - File] ), 1, 0 )