Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
I currently have a stacked bar and line chart, and I'm requring a dynamic vertical line that represents the date: TODAY() that gradually moves across the x axis throughout the year.
I know you can add similar constant lines within line charts through the Analytics tab, but this is now unavailable due to the chart being a stacked bar and line.
Is there an alternative way to achieve this on the selected chart? I would really appreciate the advice!
Solved! Go to Solution.
Hi @jh2 ,
Based on my test, after switching back to Line and Stacked column chart, the X-axis need to remove the Date hierarchy to make X-Axis constant line work.
As the screenshot shown, the original visual is drill down to Month, and the second visual is based on Day, so they are in the different hierarchies.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jh2 ,
Based on my test, after switching back to Line and Stacked column chart, the X-axis need to remove the Date hierarchy to make X-Axis constant line work.
As the screenshot shown, the original visual is drill down to Month, and the second visual is based on Day, so they are in the different hierarchies.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey, is it possible to add a vertical line for today's date while keeping the date hierarchy intact? If it is possible, could you please provide a solution for the "line and stacked column" chart?
Hi there @Greg, thanks for the advice, really appreciate it.
Tried your guidance, the line has remained but it appears to have distorted the original column stacks, as below.
@jh2 Switch to a Line chart. Add an X-Axis Constant Line in the Analytics pane based on a measure that returns today (TODAY()). Switch the visual to a stacked column and line chart. The X-Axis constant line should remain.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |