问题描述
我正在尝试比较 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:比较表格视觉对象中的两列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!