Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a line chart where I want to place a constant line on x-axis. I can do that when I have the date in x-axis field in Year-Month-Day hierarchy. As soon as i remove year from it I lose the constant line. I want to put the year in the legend instead. Has anyone been able to plot x-axis constant line on line chart with month-Day date hierarchy only?
Solved! Go to Solution.
@rishtinz You could create 2 measures, one that returns data only up to the milestone and one that returns data only after the milestone and thus have 2 different colored lines that appear contiguous.
@rishtinz Create a Month Day column perhaps? Jan 1, Jan 2, Jan 3. Super odd that the x-axis constant line goes away when you take out Year from the hierarchy but stays if you leave Year in and take out Quarter. I tested this and it is indeed the case.
Here's the output that I want. As you can see I have Year/Month/Day in the date hierarchy and so the x-axis constant works. I believe it works because its expecting a specific date and as soon as I remove year then the line disappears as well.
Now that I am thinking, this might not works since the start of the term is never a fixed date but its usually the first monday of the first week of September.
I wanted to plot a line to indicate a milestone (a date) for a year e.g. the blue line below is the milestone for this year. If I can't do this for multiple years then I guess I need to either label the marker with a different color or the line after the milestone.
I am having a similar issue. In my case, I am using the x-axis constant to indicate "this week" and shade the past weeks along an x-axis with week numbers. When I attempt to use a custom date hierarchy to facilitate year-weeknumber along the x-axis (i.e., to extend multiple years), this feature disappears from the analytics options.
How did you ultimately solve your problem?
Any other suggestions from anyone else?
@rishtinz You could create 2 measures, one that returns data only up to the milestone and one that returns data only after the milestone and thus have 2 different colored lines that appear contiguous.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |