Vertical Line in timeline chart

timeline
verticalline

#1

Hi
in eazyBI it is possible to draw a vertical line (perhaps to visualize “today”).

In order to do that, create one more calculated member in “Measures” dimension “today” that will be used as a vertical line in a chart.

That measure will compare each member from Time dimension to today’s date and display “today” only where it will match.

To create such calculated measure (it must have “integer” formatting) try this code:

IIF(
DateInPeriod(Now(), 
[Time].CurrentHierarchyMember)
, 'today', null
)

When selected, this measure could be displayed as a ‘vertical line’ after a type of the marker for this measure through legend (in a chart mode) is changed.

But be aware that it is possible only to Timeline chart in eazyBI

Martins / eazyBI support


#2

Hi @martins.vanags, this is a really interesting calculation but I can’t seem to get it to work when I try it. It looks like I’m doing exactly what you did in this post but I can’t get the vertical line. Do you have any troubleshooting/fixes that I can try?


#3

Hi @breannmcjew

It seems you missed a small part - to change the type for a measure in the chart.
Please see attached gif.

Martins / eazyBI support


#4

You’re right! Thanks so much @martins.vanags.