Hi,
Can any one please help me to apply conditional formating on below table. I have a data source like below.
I need to highlite the deals with yellow background color which comes under today date to first date of previous month i.e., Deal A comes under this category. Please help me to highlite deal a with yellow bg.
Deal | Closed Date | Today Date |
a | 1-Jan-23 | 7-Feb-23 |
b | 10-Jan-23 | 7-Feb-23 |
c | 1-Feb-23 | 7-Feb-23 |
d | 1-Jan-22 | 7-Feb-23 |
Solved! Go to Solution.
Hi @paw1 ,
Please try below steps;
1. below is my test table
Table:
2. create measure with below dax formula
Measure =
VAR _a =
SELECTEDVALUE ( 'Table'[Today Date] )
VAR _b =
SELECTEDVALUE ( 'Table'[Closed Date] )
VAR _day =
DAY ( _b )
RETURN
IF ( AND ( DATEDIFF ( _b, _a, MONTH ) = 1, _day = 1 ), "yellow" )
3. set conditional format background color for fields
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @paw1 ,
Please try below steps;
1. below is my test table
Table:
2. create measure with below dax formula
Measure =
VAR _a =
SELECTEDVALUE ( 'Table'[Today Date] )
VAR _b =
SELECTEDVALUE ( 'Table'[Closed Date] )
VAR _day =
DAY ( _b )
RETURN
IF ( AND ( DATEDIFF ( _b, _a, MONTH ) = 1, _day = 1 ), "yellow" )
3. set conditional format background color for fields
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
108 | |
63 | |
60 | |
37 | |
37 |
User | Count |
---|---|
110 | |
67 | |
62 | |
60 | |
50 |