Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to 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
Good Afternoon,
Please check my "IF" statement.
Also, please advise to resolve the error encountered.
Thank you.
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 @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.
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
Angelia - Do you know if it's possible to use this calculated column when the dates are in two different tables in the model?
I think you can best merge the column you want to compare in the other table and then follow the above steps.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |