Line Chart Display Selected Month and from First Month of Year

[archerjayden]

Hi,

I have actuals in a fact table that is connected to date table. The fact table is at Month and Year so I had created new column at power query to generate start of month date column from existing year and month columns… Joined fact with date on dates. Now I am trying to plot my actuals on Line Chart

Scenario : I would like to select a Year Month on Slicer and want to show/display Line Chart from start of year till that Selected Year Month.
The below doesnt seem to work

VAR SelectedYear =
SELECTEDVALUE ( dim_date[FiscalPeriod] )
VAR Result =
CALCULATE ( sum(vw_fct_inventory[actual])/1000000, dim_date[FiscalPeriod] <= SelectedYear )
RETURN
Result

How to achieve this please help

https://www.dropbox.com/s/qothervri3qyomu/Sample.pbix?dl=0 

Thanks
Archer

[amitchandak]

@archerjayden , if you select fewer dates and what to show more dates. You need to use an independent table.

Refer to this video

https://www.youtube.com/watch?v=duMSovyosXE