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 b...
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

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi v-deddai1-msft 

       

      Putting 2 fields into X-axis is the most effective way I can find that to make it ranking by date when I apply WeekNum.

      I tried to remove the "Date" but only keeping the Date Hirarchy, but as you can see, there is no X-axis.

       

       

       

      Maybe I get something wrong setting in Hirarchy?

       

      Can you advise where do you get the date hierarchy that can include WeekNum?

      I use calculated columns in table:

       

      Thanks.

      H

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi v-deddai1-msft , can you please try to drill down the X-axis to "WeekNum" level? I just find before down to WeekNum level at my visual, the option was available, which means available at Year, Quarter, Month, but once I drill down to WeekNum level, the option disappears.

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support
        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