Forum Discussion
Conditional Formatting
- 1 year ago
Hi, please follow these steps:
For table1 to see only future months, please create the following measure:IsFutureMonth = IF( LASTDATE('Date'[Date]) > EOMONTH(TODAY(),0), 1, 0 )For table2, to see only future and present month, please create the following measure:
IsFutureMonthPresent = IF( LASTDATE('Date'[Date]) >= EOMONTH(TODAY(),0), 1, 0 )Now lets format your visual.
Select your table1, and in the Values field, right click on desired measure and add a conditional formatting as shown bellow:
In the prompt, in format style, choose Rules based on isFutureMonth measure, and color red when the value is 1, make sure to choose number and not percent, as shown bellow:
Repeat this steps for other values that you want to format in your matrix, and for you table2, just format using the measure isFuturePresent.
Your final result should look like this:
Download the sample: Case Modelling - Copy
Thanks, unfortunately It won't accept anything in Field value:
Hi, please follow these steps:
For table1 to see only future months, please create the following measure:
IsFutureMonth =
IF(
LASTDATE('Date'[Date]) > EOMONTH(TODAY(),0),
1,
0
)
For table2, to see only future and present month, please create the following measure:
IsFutureMonthPresent =
IF(
LASTDATE('Date'[Date]) >= EOMONTH(TODAY(),0),
1,
0
)
Now lets format your visual.
Select your table1, and in the Values field, right click on desired measure and add a conditional formatting as shown bellow:
In the prompt, in format style, choose Rules based on isFutureMonth measure, and color red when the value is 1, make sure to choose number and not percent, as shown bellow:
Repeat this steps for other values that you want to format in your matrix, and for you table2, just format using the measure isFuturePresent.
Your final result should look like this:
Download the sample: Case Modelling - Copy
- ArchStanton1 year ago
Power Participant
Awesome, thanks for all of your help with this👍