topic Re: How can I color format one table with other tables values. in DAX Commands and Tips

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

aLe21 — Thu, 07 Apr 2022 19:21:58 GMT

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.

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

amitchandak — Fri, 08 Apr 2022 01:36:38 GMT

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

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

aLe21 — Fri, 08 Apr 2022 15:51:51 GMT

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

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

amitchandak — Fri, 08 Apr 2022 17:17:32 GMT

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

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

Anonymous — Wed, 13 Apr 2022 09:19:44 GMT

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