Line Chart Display Selected Month and from First Month of Year

archerjayden — Tue, 16 Mar 2021 10:14:56 GMT

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

Re: Line Chart Display Selected Month and from First Month of Year

amitchandak — Tue, 16 Mar 2021 13:32:05 GMT

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

topic Line Chart Display Selected Month and from First Month of Year in DAX Commands and Tips

Line Chart Display Selected Month and from First Month of Year

Re: Line Chart Display Selected Month and from First Month of Year