Assign colors to a column depending on a priority column

[BenWade]

Hi everyone! When I choose a particular project manager I want Project codes to be green, red or yellow depending on the budget or appointment columns(for that I can add a slicer to distinguish between budget and appointment). How to achieve it? Any ideas?

[v-zhangti · Accepted solution]

Hi, @BenWade 

Copy 2 identical tables first in Power Query. Table 1 leaves the Budget Closure column and Table 2 retains the Appointment Closure column.

Transform—Unpivot Column:

Append two tables.

Rename the column Slicer and Color.

Measure:

Color Measure = IF(SELECTEDVALUE(Append1[Slicer])<>BLANK(),SELECTEDVALUE(Append1[Color]))

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.