Forum Discussion
Today line on Gantt chart made form Matrix.
Hi Aliwells632,
If you need to add a "Today" indicator to a Gantt chart built with a matrix visual in Power BI (without using custom visuals), you can use DAX and conditional formatting as a workaround. Start by creating a calculated column in your Date table, such as IsToday = IF('Date'[Date] = TODAY(), 1, 0), to flag the current date. Next, add a column like TodayMarker = IF('Date'[Date] = TODAY(), "●", BLANK()) to show a marker (such as ●, |, or "Today").
In your matrix, place tasks as rows and dates as columns, and use TodayMarker as the value. This will add a marker under today’s date. You can also use conditional formatting to highlight the today column, making it more visible. While it won’t create a vertical line, this method makes today’s date easy to spot in your matrix Gantt chart.
Thank you.
ive added the columns to my date table.
But it wont let me add two values to the table