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 ...
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)