Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Visuals with milestone or event note?

Hi there,

 

Is there a visual can display a chart with note on timeline?

E.g. user can add note in table or anywhere else and they will be displayed with data. (please ignore the date difference between table and chart, just for example)

 

 

IMO, this will make clean & clear view on project analysis, what result is possibly triggered by what changes.

Please advise if there is a visual suppor this.

 

Thanks in advance.

H

 

Show and Tell
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    I have found the cause of the issue. the x-axis constant line only apply for continuous x-axis. When you drill down to the weeknum, it become categorical type. so the x-axis constant line disappear.

     

    You need to change your weeknum column to numeric use the following calculated column:

     

    Weeknum = WEEKNUM(Table[DATE])

     

    Then when you drill down to the weeknum level , the constant line will not disappear.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

     

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak ,

       

      Thanks for the information, this is helpful!

      I can add another Gantt chart for note below the line chart with the function: X axis constant line for line charts.

      However, I cannot find the option in my line visual.

       

      Seems the option "X axis constant line" is only availabe when it is Date in X-Axis, once I apply Hierarchy with WeekNumber, it will not available.

      I can only find "Y-Axis Constant Line"

       

       

      Could you please help to advise?

      Thanks & have a good day.

      H

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support
        5 years ago

        Hi Anonymous ，

         

        Why you need to put the two field in the x-axis? I suggest you use the build-in date hierarchy only. But based on my  test, it all works well in my environment.  Are you using the latest version of the desktop?

         

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

        Best Regards,

        Dedmon Dai