topic Re: CONSTANT LINE STACKED BAR CHART in Custom Visuals Development Discussion

CONSTANT LINE STACKED BAR CHART

Anonymous — Mon, 26 Aug 2024 15:09:42 GMT

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!!

Re: CONSTANT LINE STACKED BAR CHART

lbendlin — Mon, 26 Aug 2024 15:27:26 GMT

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.

Re: CONSTANT LINE STACKED BAR CHART

Anonymous — Mon, 26 Aug 2024 16:38:03 GMT

Can you please elaborate?

Re: CONSTANT LINE STACKED BAR CHART

lbendlin — Mon, 26 Aug 2024 16:42:57 GMT

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

Re: CONSTANT LINE STACKED BAR CHART

Anonymous — Mon, 26 Aug 2024 17:21:54 GMT

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

Re: CONSTANT LINE STACKED BAR CHART

lbendlin — Mon, 26 Aug 2024 18:49:53 GMT

Milestone column is sorted by Target Date column