Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jh2
Frequent Visitor

Vertical line to represent todays current date (dynamic) on a stacked bar chart

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!

 

Stacked Column and Line.PNG

1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

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. 

Eyelyn9_0-1645759092845.png

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.

View solution in original post

4 REPLIES 4
v-eqin-msft
Community Support
Community Support

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. 

Eyelyn9_0-1645759092845.png

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?

jh2
Frequent Visitor

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.

 

Update.PNG

Greg_Deckler
Super User
Super User

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.