Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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).
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:
Any thoughts? Thanks in advance.
Solved! Go to Solution.
Can you try DAY(TODAY()) in a measure in X-axis constant line settings?
Can you try DAY(TODAY()) in a measure in X-axis constant line settings?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
20 | |
15 | |
10 | |
10 | |
10 |
User | Count |
---|---|
15 | |
13 | |
11 | |
11 | |
10 |