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

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-deddai1-msft ,

 

Thanks for the reply.

After adding more column and make the intWeekNum to "Number",

 

I can see the option in some condition, but for following situations, there is a problem or the option is still not avaialbe:

 

If I use "Go to the next level in the Hierarchy", the option is available, but the X-axis contains no "YEAR" information.

 

 

(I've added the intWeekNum to Hierarchy)

From the upper level you can see, the Year is included in the data. So the expected result shall be the X-axis contains Year-intWeekNumber together in the first visual.

 

 

But if I use this option: Expand All Down Level in the Hierarchy, I can see the X-axis contains Year-intWeekNum which is good, but there is no "X-axis constant line" option...

 

 

 

Could you please help to this?

Thanks & have a good one.

 

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

    Hi Anonymous ,

     

    As I mentioned above, the x-axis constant line only apply for continuous x-axis.  When you Expand All Down Level in the Hierarchy ,the x-axis became categorical type. so the x-axis constant line 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