Forum Discussion
Solved
Conditional format bar chart based on column output
Hi I require a DAX measure so that I can conditionally format the SurveyYear column in a bar chart with the following criteria If the survey year is current year, current year -1, curren...
Hi cottrera,
The error is because your "Year" column has some string called "No Survey" and the subtraction happening below is not able to process the string. So, we can modify MFelix 's measure as following:
Year condittional formatting = VAR _YearValue = SELECTEDVALUE(Table[SurveyYear]) RETURN IF(_YearValue = "No Survey", "#FF0000", SWITCH ( TRUE (), CONVERT(_YearValue,INTEGER) - YEAR ( TODAY ) > - 5, "#53DA65", CONVERT(_YearValue,INTEGER) - YEAR ( TODAY ) > - 10, "#FFA500", CONVERT(_YearValue,INTEGER) - YEAR ( TODAY ) > - 15, "#FF0000", "#FF0000" ) )Please mark it as a solution.
Regards,
Tez147
Hi MFelix thank youfor your quick response. I have added the DAX as a column measure and amended the table / column name. However I am getting this error
The MAX function only accepts a column reference as an argument.
Year condittional formatting =
VAR _YearValue =
MAX ( CONVERT (Last_Stock_Survey[SurveyYear], DOUBLE ) )
RETURN
SWITCH (
TRUE (),
_YearValue - YEAR ( TODAY ) > - 5, "#53DA65",
_YearValue - YEAR ( TODAY ) > - 10, "#FFA500",
_YearValue - YEAR ( TODAY ) > - 15, "#FF0000",
"#FF0000"
)
Hi cottrera ,
I changed the order of the syntax must be:
Year condittional formatting = VAR _YearValue = CONVERT ( MAX(Table[SurveyYear]), DOUBLE ) RETURN SWITCH ( TRUE (), _YearValue - YEAR ( TODAY ) > - 5, "#53DA65", _YearValue - YEAR ( TODAY ) > - 10, "#FFA500", _YearValue - YEAR ( TODAY ) > - 15, "#FF0000", "#FF0000" )
