Multiple Filter in the Report

[Anonymous]

Hello All,

I am trying to create a report page this is how the report page looks like - 

What I would like to do is based on the date week duration selected in the slicer, I would like to show Last 8 Weeks in ticket volume by month.

Is there a way to accomplish this.

Thanks in advance.

[amitchandak]

@Anonymous , see if my WOW can help to create the required columns

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

[Greg_Deckler]

@Anonymous - Yes, I have an example of this with a matrix in Complex Selector - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

Pages 2 and 3

[Anonymous]

Hey @Greg_Deckler 

This works perfectly but it causes a problem if I want to create metrics where if I have to use any categories like Priority, Location, etc.

I have seen the file and you have created complex queries but is there any other way to do it. 

Similar to your calculation I made an additional calculation which will just take the max week but it does not work.

Include Data Week = 
VAR __SlicerWeek = MAX('Week Sequence Number'[Week Sequence Number])
VAR __MinWeek = __SlicerWeek - 8
VAR __CurrentWeek = MAX('Calendar - Date'[Week Sequence Number])

RETURN
    IF(__CurrentWeek = __SlicerWeek,1,0)