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

     

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