Help with coloring cells in a report

[fcojnav78]

Dear community,

I created a report that prioritizes the issues due this week (due date is based on a date entered by the project user). I would like to be able to color the issue based on the current day and the upcoming days. For example:

• If today is Monday and the Monday column in the report shows I have issues due (at any level), highlight the cell in red.

• If there are tickets due in two more days, highlight them in yellow, and after that, highlight them in green.

[martins.vanags]

Hi @fcojnav78

Try using this custom formula for Cell formatting on your calculated measure “Proximos a vencer”

CASE WHEN
[Measures].[Próximos a vencer]>0
AND
  DateInPeriod(
  [Time.Weekly].CurrentMember.StartDate,
  [Time.Weekly].[Week].CurrentDateMember
  )
THEN
  CASE
  WHEN --if weekday displayed is past 
    Cast([Week Day].CurrentMember.key as integer)<
   Cast([Time.Weekly].[Day].CurrentDateMember.get('Week day') as integer)
  THEN 1
  WHEN --if weekday is current day
  [Week Day].CurrentMember.name
  = [Time.Weekly].[Day].CurrentDateMember.get('Week day name')
  THEN 2
  WHEN --if weekday is future day
    Cast([Week Day].CurrentMember.key as integer)>
   Cast([Time.Weekly].[Day].CurrentDateMember.get('Week day') as integer)
  THEN 3
  END
END

It should color days behind in red, current day in orange and future days in green

Martins / eazyBI

[fcojnav78]

Thank´s a lot Martins¡..