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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
aLe21
New Member

How can I color format one table with other tables values.

Hello,

 

Im building a training report, in which i have which trainings each person of the company took.

According to the persons role, the different trainings they should take.

So, in conclusion, i have a table with the modules they took and another table with the modules they should take. I would like to colour the table like this (in green the modules taken and in red the modules they still havent done)

 

The modules that are on the left table should be coloured in green on the 2nd table.

All this is filtered by person.

aLe21_0-1649359275490.png

 

Hope its clear.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @aLe21,

You can get the current user id and use it as conditions to use it to lookup the 'status' table to confirm the corresponding training status, then return the color code and apply it to the conditional formatting feature.

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

If you are confused about the coding formula, please share some dummy data to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

HI @aLe21,

You can get the current user id and use it as conditions to use it to lookup the 'status' table to confirm the corresponding training status, then return the color code and apply it to the conditional formatting feature.

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

If you are confused about the coding formula, please share some dummy data to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

amitchandak
Super User
Super User

@aLe21 , Not ver clear. But you can create color measure based on condition and use that in conditional formatting using field value options

example

if(FIRSTNONBLANK('Table'[Value],"true")= "true","green","red")

 

if(FIRSTNONBLANK(date[date],blank())= today(),"green","red")

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak thanks for your reply, couldnt make it work still.

 

Let me try to explain it in a different way.

I have 1 table with tasks done and another table with tasks should be done.

So, when i select one person, i want to see on the table with all the tasks which one of those have been done. And thats what i would like to see quickly with colours, on red what tasks havent been done and on green which ones yes.

 

Regards

@aLe21 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.