Forum Discussion
Conditional formatting in matrix table
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)?
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
2 Replies
apply the same color rule to the background and to the value.
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
