Forum Discussion

Yuriy's avatar
Yuriy
Frequent Visitor
9 years ago

line chart dynamic end date

I created line chart. For example I have a data value for 01.01.2017 00:00:00 only.
I need to see chart for the whole day -  from 00 to 23 hour with empty data value.
For this I can use the "end date" prorerty for X-axis (set to 02.01.2017).
On the next date I need to change the "end date" prorerty for X-axis to 03.01.2017

How it is possible to set the "end date" prorerty for X-axis dynamicly?

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi Yuriy,

     

    The "end date" is a property of the "Format". So it can't by changed dynamically. But there is another way to achieve your goal. Please reference this file: https://1drv.ms/u/s!ArTqPk2pu-BkgRIUfNnjO8HTfJ0A

    1. Create a date table that contains time.

    Calendar =
CROSSJOIN (
    CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) ),
    GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 0, 0 ), TIME ( 1, 0, 0 ) )
)

    2. Create a line chart with date and time in the axis. Drill down.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi Yuriy,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale