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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Marking Today's Date with a Line on the Line Chart

Hello!

I have this line chart and was asked to mark today's date with a vertical line (same one that appears when the mouse point rolls over).  Is it possible to do that? I've created a "today's date" column, but not sure how to make it work.

Thank you!

Capture2.JPG

2 ACCEPTED SOLUTIONS

@Anonymous glad to help, feel free to reach out if need any assistance. Accept the solution if it is working as expected so that others can take advantage of it.

 

Cheers,

Parv



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

@Anonymous oh that table is created using DAX under Data Table

 

go to modelling tab, click new table  and add expression to create the table

 

 

image.png



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

21 REPLIES 21
Anonymous
Not applicable

Hi @parry2k ,

 

I came across this thread and I'm hoping you might be able to help me out as well. I would also like to create a today line, however the figure I would like to add it to currently dislays a measure as its line value that is a bit more compicated than the SUM measures used in this example. My measure is as follows:

E_date approved = calculate(DISTINCTCOUNT(MilestonesAndDependencies[Milestone Name]), filter(allselected(MilestonesAndDependencies), MilestonesAndDependencies[End date approved] > min(MilestonesAndDependencies[End date approved])))
 
The measure above basically enables me to show a burndown chart that displays when something should be implemented, according to the date that was stated as the [end date approved] at the start of our project:
 
Odi_0-1614954649406.png

However when i apply your method the best result so far is this:

Odi_1-1614954699629.png

Am i missing something, or does your method perhaps not work when using more complicated measures as lines?

Any help will be greatly appreciated.

kind regards,
Odi

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors