Forum Discussion
Display amount based on multiple date columns on X axis (MM/YYYY) in line chart
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
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.
2 Replies
Thank you very much for the well described solution!
Best regards,
Reinhard
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.
