Forum Discussion
Filter a Matrix based on slicers/measures
- 7 years ago
Depends. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
You could create a filtering measure the reports back if a row in your matrix falls within the report start and end date but the specifics of that are tough to pin down without sample data.
- 7 years ago
Accomplished what I was trying to do.
Filter Month = IF(AND(MAX(Run_Data[Date])>=[Report Start Date Month],MAX(Run_Data[Date])<=[Report End Date]),1,2)
Filter Year = IF(AND(MAX(Run_Data[Date])>=[Report Start Date Year],MAX(Run_Data[Date])<=[Report End Date]),1,2)
Then I had to ensure that Sync Slicers was selected on the view tab. (Missed that)
Since I was setting the page up as static for a particular region, I was able to set up two matrix.
1st Matrix I set the Filter Month = 1
2nd Matrix I set the Filter Year = 1
Now I have:
Thanks Greg_Deckler for leading me down the right path.
Depends. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
You could create a filtering measure the reports back if a row in your matrix falls within the report start and end date but the specifics of that are tough to pin down without sample data.
Here is the file I am using.
The dropdown selections are on the first page, and the matrix is on the third page.