topic Add vertical line to mark current day in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-vertical-line-to-mark-current-day/m-p/4020284#M158601 <P>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.</P><P>&nbsp;</P><P>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).</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>DAX code is here for the current day marker:&nbsp;</P><P><SPAN>Current Day Marker = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>('FactsheetApproval'[DayOfMonth2]) = </SPAN><SPAN>DAY</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>()), </SPAN><SPAN>3</SPAN><SPAN>, </SPAN><SPAN>0</SPAN><SPAN>)</SPAN></P><P>&nbsp;</P><P>I tried it via the X-axis constant line settings but the marker is stuck at zero when i do this:</P><P>&nbsp;</P><P><img /><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Any thoughts? Thanks in advance.</P><P>&nbsp;</P> Tue, 02 Jul 2024 10:54:37 GMT swanpaws 2024-07-02T10:54:37Z Add vertical line to mark current day https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-vertical-line-to-mark-current-day/m-p/4020284#M158601 <P>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.</P><P>&nbsp;</P><P>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).</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>DAX code is here for the current day marker:&nbsp;</P><P><SPAN>Current Day Marker = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>('FactsheetApproval'[DayOfMonth2]) = </SPAN><SPAN>DAY</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>()), </SPAN><SPAN>3</SPAN><SPAN>, </SPAN><SPAN>0</SPAN><SPAN>)</SPAN></P><P>&nbsp;</P><P>I tried it via the X-axis constant line settings but the marker is stuck at zero when i do this:</P><P>&nbsp;</P><P><img /><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Any thoughts? Thanks in advance.</P><P>&nbsp;</P> Tue, 02 Jul 2024 10:54:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-vertical-line-to-mark-current-day/m-p/4020284#M158601 swanpaws 2024-07-02T10:54:37Z Re: Add vertical line to mark current day https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-vertical-line-to-mark-current-day/m-p/4020538#M158614 <P>Can you try <STRONG><SPAN>DAY</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>())</SPAN></STRONG> in a measure in <STRONG>X-axis constant line settings</STRONG>?</P> Tue, 02 Jul 2024 13:12:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-vertical-line-to-mark-current-day/m-p/4020538#M158614 HotChilli 2024-07-02T13:12:51Z Re: Add vertical line to mark current day https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-vertical-line-to-mark-current-day/m-p/4020674#M158623 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="81111" data-lia-user-login="HotChilli" class="lia-mention lia-mention-user">HotChilli</a>&nbsp;</P> Tue, 02 Jul 2024 14:08:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-vertical-line-to-mark-current-day/m-p/4020674#M158623 swanpaws 2024-07-02T14:08:49Z