CONSTANT LINE STACKED BAR CHART

[Anonymous]

The bar plot shown below was created using Python and seperates the bars based on Today's date.



I am able to recreate the stacked bar plot in Power BI but facing trouble while trying to add a constant line based on TODAY() horizontally.

This is what I get when I attempt to add a constant line

These are my constant line settings ( Also I am not sure how to base the constant line using TODAY()'s date )

Any help is appreciated. Thanks!!

[lbendlin]

Your Y axis is text. How are you sorting that column?  You could add a fake "Today"  value without data (or a small amount) and then manipulate the sort order of the text values accordingly.

[Anonymous]

Can you please elaborate?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

For the sample data (below) , a stacked bar plot would like the one pasted (above). I have sorted the axis in the ascending order of Target Date.
Expected result: Similar bar plot with constant line for today()

Sample Data: 

Milestone	Target Date	Accepted Points	Total Points	Remaining Points
Project Kickoff	2/1/2024	30	50	20
Design Phase	3/15/2024	45	60	15
Dev Phase	5/30/2024	70	100	30
Test Phase	6/15/2024	50	70	20
User Acceptance Testing	7/20/2024	40	50	10
Project Launch	8/30/2024	60	80	20

[lbendlin · Accepted solution]

Milestone column is sorted by Target Date column