Forum Discussion
Solved
conditional formatting in a column chart
HI in my monthly report where the user must select a month i have all my visual affected by that month slicer. But i add one visual where i want to show : the total spend from the begining...
Hi JUANROVALETTI ,
I suggest you to create an unrelated calendar table to help your calculation.
Unrelated DimMonth = CALCULATETABLE('Calendar')Measure:
Month Spend = VAR _SELECTYEARMONTH = SELECTEDVALUE('Unrelated DimMonth'[YearMonth]) RETURN CALCULATE(SUM('Table'[Sales]),'Calendar'[YearMonth] = _SELECTYEARMONTH)Color = VAR _SELECTMONTH = SELECTEDVALUE('Unrelated DimMonth'[MonthName]) RETURN IF(MAX('Calendar'[MonthName]) = _SELECTMONTH,"Yellow")Configure the column color as below.
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JUANROVALETTI I see, in the column chart you want to change the color of the bar for the selected month, correct?
yes.
Hi JUANROVALETTI ,
I suggest you to create an unrelated calendar table to help your calculation.
Unrelated DimMonth = CALCULATETABLE('Calendar')Measure:
Month Spend = VAR _SELECTYEARMONTH = SELECTEDVALUE('Unrelated DimMonth'[YearMonth]) RETURN CALCULATE(SUM('Table'[Sales]),'Calendar'[YearMonth] = _SELECTYEARMONTH)Color = VAR _SELECTMONTH = SELECTEDVALUE('Unrelated DimMonth'[MonthName]) RETURN IF(MAX('Calendar'[MonthName]) = _SELECTMONTH,"Yellow")Configure the column color as below.
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.