Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello everyone,
i know that Power Bi has the possibility to make some conditional formatting for columns or specific rules. But is it possible to coloring ONLY values which came from other tables. In excel it would look like the example below.
In Power BI have now the following matrix and the columns are calculated with the following measure
April =
IF (
SUM ( 'Table'[April TEUR] ) > 0,
SUM ( 'Table1'[April TEUR] ),
SUM ( 'Table1'[April Actuals] )
)
So what I wanted to do ist to coloring the values which came from the 'Table1'[April Actuals] with blue or other color. Is this possible?
Thank you in advance for your help 🙂
Solved! Go to Solution.
Based on your description, you need to set different backgroud color for the data from different table, right? Currently, there is no such a functionally to acheive this requirement, here is a similar issue, please refer to the link below.
https://community.powerbi.com/t5/Desktop/Conditional-formatting-based-on-dynamic-values/m-p/177823#M...
If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Thank you for your understanding.
Regards,
Charlie Liao
Based on your description, you need to set different backgroud color for the data from different table, right? Currently, there is no such a functionally to acheive this requirement, here is a similar issue, please refer to the link below.
https://community.powerbi.com/t5/Desktop/Conditional-formatting-based-on-dynamic-values/m-p/177823#M...
If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Thank you for your understanding.
Regards,
Charlie Liao
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 90 | |
| 78 | |
| 66 | |
| 65 |