Forum Discussion
CONSTANT LINE STACKED BAR CHART
Milestone column is sorted by Target Date column
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-Forum/ba-p/963216
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/1447523
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 |
Milestone column is sorted by Target Date column