3 Replies Latest reply on Jun 21, 2017 4:39 AM by Michael Gillespie

    Background color banding by calculated member

    Felipe Piedrabuena

      Hi all,

      I'm new here and I' ve got an issue to fill background color only for current month. I've been reading lot of posts but none of them solves my problem.

      As you can see in the image below I have divided the time in the two axis, month in rows and days in columns.

       

      On each cell there is an icon that represents a type for shaping and state for colour and what I want is to include one more value from a calculated member (Current Month) to fill background row color.

      Calculated member Current Month:

      IF DATEPART('month', [Fecha Limite])=DATEPART('month', TODAY())

      THEN "Current"

      ELSE "Other"

      END

       

      My current graphic:

      background_color_banding.png

       

      Final graphic should be something like:

      background_color_banding_solve.png

       

      Sorry for not sharing any workbook but I'm managing sensitive data.

       

      Many thanks in advance and forgive my english,

      Felipe