Power BI:比较表格视觉中的两列 [英] Power BI: Compare two columns in a table visual

问题描述

我正在尝试比较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:
https://community.powerbi.com/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 )

这篇关于Power BI:比较表格视觉中的两列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！