Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have this graph, with the slicer on the right hand side selecting for dates.
The line there is a dynamic line from a measure with the code 'Today()', i.e. the dotted blue line is always on today.
I need either:
How can I acheive this?
Solved! Go to Solution.
@Anonymous , You can create a measure and use in x-axis constant line using FX
if(Today() >= minx(allselected('Date'), 'Date'[Date]) && Today() <= maxx(allselected('Date'), 'Date'[Date]) , today() , blank())
for buttons consider Bookmarks and buttons
Bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
I have no bookmarks pane in my powerbi desktop. How can I enable it?
@Anonymous , You can create a measure and use in x-axis constant line using FX
if(Today() >= minx(allselected('Date'), 'Date'[Date]) && Today() <= maxx(allselected('Date'), 'Date'[Date]) , today() , blank())
for buttons consider Bookmarks and buttons
Bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks