Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Billy0503
Frequent Visitor

Coloring specific values from different tables

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.

 

Example.PNG

 

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] )
)

 

PowerBi.PNG

 

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 🙂

 

 

 

 

1 ACCEPTED SOLUTION
v-caliao-msft
Microsoft Employee
Microsoft Employee

@Billy0503,

 

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

 

View solution in original post

1 REPLY 1
v-caliao-msft
Microsoft Employee
Microsoft Employee

@Billy0503,

 

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

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.