Display amount based on multiple date columns on X axis (MM/YYYY) in line chart

[waldnerr]

Hi,

i have a fact table, where columns for "Final Acceptance Date Best Case" and "Final Acceptance Date Worst Case" are included per project and evaluation month:

Evaulation Month	Project	Final Acceptance Date Best Case	Final Acceptance Date Worst Case (Calculated Column)	Total Contract Value
10/23	A	31.12.2023	01.04.2024	500000
10/23	B	10.10.2023	10.10.2023	300000
10/23	C	15.11.2023	14.12.2023	200000
09/23	A	31.12.2023	31.12.2023	450000
09/23	B	10.10.2023	10.10.2023	250000
09/23	C	15.11.2023	0112.2023	200000

I would like to create a line chart based on the "Evaluation Month" 10/23, where i show month/year on the X axyis and two lines for Total Contract Value (TCV) on the Y axis - one based on "Final Acceptance Best Case" and one on "Final Acceptance Worst Case":

I would appreachiate, if you could give me feedback, how to acieve the desired result.

Thank you,

Best regards,

Reinhard

[waldnerr]

Thank you very much for the well described solution!

Best regards,

Reinhard

[mickey64 · Accepted solution]

For your reference.

Step 0: I unpivot 2 columns and rename a title of the column in Power Query Editor.

Step 1: I make a calendar table and add a relationship in Power BI Desktop.

Step 2: I make a measure.

    TCV TOTALYTD = TOTALYTD(SUM(DATA[Total Contract Value]),'Calendar'[Date],"9/30")

Step 3: I make a graph and 2 slicers.