Conditional formatting in matrix table

[jalaomar]

Dear all,

I am creating a matrix table where I have a list of Projects and I would like to visualize the which tollgate each projects are in.

that information is based on the actual start date.

How can I create a conditional formatting so that the actual dates are a background color instead (don't want to show the value only the background color)?

[Anonymous · Accepted solution]

Hi  @jalaomar ,

I created some data:

Put into the matrix:

Here are the steps you can follow：

1. Create measure.

Measure =
SWITCH(
    TRUE(),
    MAX('Table'[Date])>=DATE(2019,7,29)&&MAX('Table'[Date])<=DATE(2020,1,1),"red",
    MAX('Table'[Date])>=DATE(2020,1,2)&&MAX('Table'[Date])<=DATE(2020,6,23),"yellow",
    "green")

2. Format – Conditional formatting – select the Date field – open the Background color.

3. Enter the Background color interface, Format by – Field value, Based on field – [Measure].

4. Result:

Best Regards,

Liu Yang

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

[lbendlin]

apply the same color rule to the background and to the value.