Forum Discussion
CONSTANT LINE STACKED BAR CHART
Milestone column is sorted by Target Date column
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.
Can you please elaborate?
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/1447523For 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