Forum Discussion
Solved
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...
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.
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.