Colors for the same members

Mai Farid

I made the graph but I want to make this graph in colors, for before this week I want to make it green and for this week is orange and for the future is blue. So Is it possible to make like that in eazyBI?? If yes please tell me how

 

The blue graph is my eazyBI graph.

 

Lauma Cīrule

Hi!

For now, it is not possible to dynamically change the colors of one measure in eazyBI. What you could do to create such report is to create three calculated members which each would return the value of measure only in case the time falls before, now or after the period of Time dimension. See screenshot below

The formulas I used are as follows (I am using Issues with due date Measure, please change it accordingly).

Before today

CASE WHEN 
 DateAfterPeriodEnd(
   Now(),
   [Time].CurrentHierarchyMember
 )
THEN [Measures].[Issues with due date]
END

This period

CASE WHEN 
 DateInPeriod(
   Now(),
   [Time].CurrentHierarchyMember
 )
THEN [Measures].[Issues with due date]
END

After today

CASE WHEN 
 DateBeforePeriodEnd(
   Now(),
   [Time].CurrentHierarchyMember
 ) AND NOT 
 DateInPeriod(
   Now(),
   [Time].CurrentHierarchyMember
 )
THEN [Measures].[Issues with due date]
END

Note that I have stacked the bars to show them in all provided area of that time period.

Lauma / support@eazybi.com