Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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
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
@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
@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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |