Compare two columns in a table visual

[abhay03]

In a table, I want to compare two columns side by side and highlight the differences like second image below:

How can this be achieved in a Table visual in Power BI? 

[AbegaelFollero]

Good Afternoon,

Please check my "IF" statement. 

Also, please advise to resolve the error encountered.

Thank you.

[TERRY_HUGHES]

This isn't a solution Abegael, it produces an error

[Fraukje]

Hi @abhay03,

If you are using a Table type of visual, you can use 'Conditional formatting'. Did you check this out yet?

Check out https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/

for more info.

[abhay03]

Hi @Fraukje,

Conditional formatting gives the option to format a single column. In my case, I'm looking to format one of the columns after comparing it to another column.

[v-huizhn-msft · Accepted solution]

Hi @abhay03,

Until now, custom color isn't supported in Power BI, please review the feature requests and vote them. 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17339728-more-flexible-conditiona...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16417966-conditional-formating-fo...

For your requirement, you can create a calculated column using the formula below.

Flag = IF(Test[Sales-DB]=Test[Sales_File],1,0)

Then you can use conditional formatting to set the color of Flag column as follows.


You will get the result.



Best Regards,
Angelia

[amyod]

Angelia - Do you know if it's possible to use this calculated column when the dates are in two different tables in the model?

[Anonymous]

I think you can best merge the column you want to compare in the other table and then follow the above steps.