Forum Discussion
Date Reference Lines Based on Slicer
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!
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
3 Replies
- lbendlin
Super User
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
- AnonymousNot applicable
This is gold! Thank you for sharing!
- lbendlin
Super User
yes, I was really happy to see that implemented. I have wanted that for a long time.