Date Reference Lines Based on Slicer

[Anonymous]

Hi, I've looked through the forums around the topic of reference lines but it seems everyone is only concerned with either a specific date (min, max) or today's date. However, I have a date slicer which I would like to create two reference lines on my line graph visual.

So far, I have tried working with the solutions in the forum but the max date is the only result I seem to get. I've tried to hard code a reference line on the graph but I get multiple lines for some reason.

Ideally, I would like to have two reference lines: FIRSTDATE() and LASTDATE() on my slicer. For example, in my slicer I have 2/8 - 2/19 therefore my reference lines should highlight data in that range. (Note: graph drawn in paint app, it's just a rough image of end goal)

If reference lines is not possible, is it possible to shade the area a different color?

I share my pbix file on OneDrive:  Date Reference Lines Based on Slicer 

Thanks in advance!

[lbendlin · Accepted solution]

I think you will be happy to see the new features in the August 2021 Power BI desktop.

Power BI August 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

[Anonymous]

This is gold! Thank you for sharing!

[lbendlin]

yes, I was really happy to see that implemented. I have wanted that for a long time.