Forum Discussion
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?
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
7 Replies
This isn't a solution Abegael, it produces an error
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.
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
