Forum Discussion
Visuals with milestone or event note?
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
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
Community SupportHi 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
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
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
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
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.