Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have one data set which contains data for multiple months and would like to add two bar charts beside each other for a quick comparisson (this month vs last month, see screenshot):
The problem is when one date range is changed it affects both graphs, how can I couple each date filter with each graph so that I can only see the data filtered by that date filter?
Solved! Go to Solution.
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:
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:
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.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |