Forum Discussion
eliasayyy
Memorable Member
Memorable MemberCreate line chart based on filtering date
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...
i found a slution , create a new calander table completely separt no relationships
create a measureFiltering = 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 measureLine Chart Sales = CALCULATE([Sales],REMOVEFILTERS(Calander[Date]),Calander[Date] = MAX('Calander Inactive'[Date]))
eliasayyyMemorable Member
Memorable Memberi 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]))