Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
UserHeretic
Regular Visitor

Including a specific Date in a Line Chart

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.

1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

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:

 

vertical line.PNG

 

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.

View solution in original post

6 REPLIES 6
v-eqin-msft
Community Support
Community Support

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
Community Support
Community Support

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:

 

vertical line.PNG

 

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
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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.

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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.

 

UserHeretic_0-1621002741629.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.