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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
swanpaws
Frequent Visitor

Add vertical line to mark current day

Hi, is it possible to add a line to a chart based on a measure. I am hoping to acheive the equivalent of a constant line (vertical dashed line) which reflects the day in the month of today's date.

 

I have managed to add a pointer to the current chart but it''s not ideal as I was hoping for a constant vertical line (which shifts each day when report refreshed).

 

swanpaws_0-1719917175929.png

 

 

swanpaws_1-1719917207550.png

 

DAX code is here for the current day marker: 

Current Day Marker = IF(MAX('FactsheetApproval'[DayOfMonth2]) = DAY(TODAY()), 3, 0)

 

I tried it via the X-axis constant line settings but the marker is stuck at zero when i do this:

 

swanpaws_2-1719917481319.pngswanpaws_3-1719917514746.png

 

 

Any thoughts? Thanks in advance.

 

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

Can you try DAY(TODAY()) in a measure in X-axis constant line settings?

View solution in original post

2 REPLIES 2
swanpaws
Frequent Visitor

Thanks @HotChilli 

HotChilli
Super User
Super User

Can you try DAY(TODAY()) in a measure in X-axis constant line settings?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.