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.
Hi, Miko!
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 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 period.
Lauma / support@eazybi.com
Thank you so much. You helped me alot 
I have another issue I want another report but with weeks
I need for this week, last week, and before
I only made this week and before and I don’t know how to make the previous week. Could you help me?
Closed CRs this week
CASE WHEN
DateInPeriod(Now(),[Time].CurrentHierarchyMember)
THEN
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issue type] = ‘CR’
and ([Measures].[Status] <> ‘Canceled WA’
and [Measures].[Status] <> ‘Canceled NA’)
), [Measures].[Issues with closure date])
END
Closed CRs before this week
CASE WHEN
DateAfterPeriodEnd(Now(),[Time].CurrentHierarchyMember)
THEN
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issue type] = ‘CR’
and ([Measures].[Status] <> ‘Canceled WA’
and [Measures].[Status] <> ‘Canceled NA’)
), [Measures].[Issues with closure date])
END
Hi Miko!
To only show specific period of time it is not necessary to create calculated members. You can click on any time member and specify Time filter. See
Let me know if this is what you were looking for or if you have any additional questions.
Lauma / support@eazybi.com
Hi Lauma,
I know about filter but I need it like the first graph. The old one is in color, previous week in another color and this week in another color.
any update please about how to make last week??
Hi Miko!
Sorry for not noticing your answer earlier! I see your point.
To get the previous week you can use the following format
CASE WHEN
DateInPeriod(
DateParse('one week ago'),[Time].CurrentHierarchyMember)
THEN
...
END
Let me know if that helped!
Lauma / support@eazybi.com
Thank you. it worked.