Including a specific Date in a Line Chart

[UserHeretic]

I'm a relatively new Power BI user and am looking to make a line chart that denotes a specific date in the data. Ideally, I am looking to create a measure that will show a specific date as a mark on each of multiple lines. If that isn't possible, I would like to create a measure that will show up as a vertical line where the specified date falls on the x-axis.

My data is set up such that each line is part of a different table. Each table is linked through a reference table that includes a month and year value.

Thank you for your help.

[v-eqin-msft]

Hi @UserHeretic ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you😀

Best Regards,
Eyelyn Qin

[v-eqin-msft · Accepted solution]

Hi @UserHeretic ,

According to my understanding, you want to add a vertical line to a chart,right?

To my knowledge, it's not availavle currently in Power BI, but you could take a look at this workround:

I believe you can get more hints from these threads:

Adding a vertical line or marker to a chart in Power BI - Prathy's Blog...

Solved: Reference Line on x-axis - Microsoft Power BI Community

Dynamic vertical reference line in Line Chart - Power BI - Enterprise DNA Forum

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11]

Hi @UserHeretic ,

You will need to add more details to your query.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati

[UserHeretic]

After reading the article you provided I'm not sure what more information I should provide, but I will give it my best shot.

My data is incremental, with one data point recorded each month on the first day of the month. I have a line chart that shows spending data across one fiscal year. The data is drawn from three different tables. Each table contains a column denoting the date and are linked in my schema with a reference table that contains a single column that has unique date values for each of the dates contained in the other tables. I am attempting to mark on each line a single date (e.g. April 1st).

Does that include enough information to help clarify the problem?

My data is incremental, with one data point recorded each month on the first day of the month.

[Pragati11]

Hi @UserHeretic ,

By additional information I need some screenshot around

1. what data you have (may be some sample data)
2. what data model you have got
3. what kind of visuals you have in your report
4. A sample visual that you want to achieve.

Thanks,

Pragati

[UserHeretic]

Alrighty, I can't share the specific information, but I can share a sample data set that I created. I am not sure how to create the effect I'm looking for in Excel either, but I can describe it verbally. I am trying to place a marker on each line on the date of 4/1/2021.