Forum Discussion
Multiple date fields on one report
- 5 years ago
Hi sdc ,
Try modifying EDIT INTERACTIONS for your charts.
Consider following report page: I have got a MONTH filter here on the right.
Now suppose I want this filter to work only on the 3rd Table from left, I can modify it's interactions as follows:
- Click on MONTH slicer
- Under FORMAT options on the top ribbon, select Edit Interactions
- Once you click on edit interactions you will see following:
- Now you see 2 icons on the top right of all the 3 tables.
- Click on circular icon to stop that table visual from getting filtered from the MONTH slicer.
Once that is done, 1st and 2nd tables from left, don't get filtered on selecting values from the MONTH slicer as shown below:
So if you see the above GIF, only the 3rd table is getting filtered from the SLICER, not the other 2 from the left.
Apply similar kind of edit interactions in your case for both the slicers.
For more details on Edit Interactions refer following:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Thanks,
Pragati
Hi sdc ,
Try modifying EDIT INTERACTIONS for your charts.
Consider following report page: I have got a MONTH filter here on the right.
Now suppose I want this filter to work only on the 3rd Table from left, I can modify it's interactions as follows:
- Click on MONTH slicer
- Under FORMAT options on the top ribbon, select Edit Interactions
- Once you click on edit interactions you will see following:
- Now you see 2 icons on the top right of all the 3 tables.
- Click on circular icon to stop that table visual from getting filtered from the MONTH slicer.
Once that is done, 1st and 2nd tables from left, don't get filtered on selecting values from the MONTH slicer as shown below:
So if you see the above GIF, only the 3rd table is getting filtered from the SLICER, not the other 2 from the left.
Apply similar kind of edit interactions in your case for both the slicers.
For more details on Edit Interactions refer following:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Thanks,
Pragati
Yes that does it, thanks a lot.
One last question on the date filters, how to make it so that one filter always starts on the current month and the other on the previous month like so.