Forum Discussion

abhay03's avatar
abhay03
Helper I
8 years ago
Solved

Compare two columns in a table visual

  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? 
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

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-conditional-formatting-in-tables-and

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16417966-conditional-formating-for-table-and-matrix

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's avatar
amyod
Frequent Visitor
4 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

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