Sum of Sales in Line chart until the week selected in the Date slicer

[ManishShetty]

Hi,

I'm creating a sales dashboard with visual cards and line chart based on the FiscalYearWeek selection in a dropdown. I'm having trouble with making the line chart work with the type of week slicer that I'm using. 

I want to keep the slicer dropdown values in this format.

When I try to display the total sales in a linechart until the (last day of) selected week, it appears as a single dot for that specific week instead of summing the sales from the first day of the year to the week selected. 

This is how I want it to function: weeknumber 5 is selected within the Week slicer. The line-chart should display the cumulative sum of sales until week 5.

I'm trying to avoid using hierarchy as it doesn't display the week chosen by the user correctly when there are multiple selections.

Any suggestions as to how to make this work?

Thanks in advance!

[Ashish_Mathur]

Hi,

I am not sure of how much i can help but i would like to try.  Share the download link of the PBI file.

[amitchandak]

@ManishShetty , when you select one date/period and want to display more than that you need an independent date table for slicer

You can use date of Yearweek (yyyyww format)

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI