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

[aLe21]

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.

Hope its clear.

[Anonymous · Accepted solution]

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]

@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

[aLe21]

@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

[amitchandak]

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