Forum Discussion
Multiple Filter in the Report
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.
3 Replies
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
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)
Anonymous , see if my WOW can help to create the required columns
