Create line chart based on filtering date

eliasayyy — Fri, 28 Apr 2023 11:49:08 GMT

Hello everyone,

i have a slicer that seelcts week number

i have a line chart , x-axis is date and y-axis is total sales

i created a measure to calculate last week sales called Previous week sales

today is Friday 28 april 2023 which is week 18

week 18 starts from monday 24 2023 and ends sunday 30 2023

week 17 starts monday 17 2023 and ends sunday 23 2023

if i selected week 18 on my slicer

i want the line chart to return dates from monday 17 to max date which is sunday 23

how can i achieve this?

tamerj1 johnt75 FreemanZ amitchandak

Re: Create line chart based on filtering date

eliasayyy — Fri, 28 Apr 2023 12:29:17 GMT

i found a slution , create a new calander table completely separt no relationships

create a measure

Filtering = VAR selectedweek = MAX(Calander[Week ID]) VAR lastweek = selectedweek - 1 VAR weekstart = CALCULATE(MIN(Calander[Date]),REMOVEFILTERS(Calander[Date]),Calander[Week ID] = lastweek) VAR weekend = MAX(Calander[Date]) VAR result = IF(AND(MIN('Calander Inactive'[Date]) >= weekstart, MAX('Calander Inactive'[Date]) <= weekend), 1, 0) RETURN result

add the date from seperate calendar table to line chart on x-axis

create a new measure

Line Chart Sales = CALCULATE([Sales],REMOVEFILTERS(Calander[Date]),Calander[Date] = MAX('Calander Inactive'[Date]))

topic Create line chart based on filtering date in DAX Commands and Tips

Create line chart based on filtering date

Re: Create line chart based on filtering date