Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Can I use the filters for created date and close date as the same filter? I have 2 reports. The first report is the number of sales made each month. And the second report is sales for each month. Which is displayed by the closing month or closing date. Is there any way to select Monthly Filter and both reports will display correctly? Can anyone find a solution to this problem, thank you very much.
Solved! Go to Solution.
Hello,
You could build a seperate date table where you have all the dates in your data with year, month, and day columns.
check this video to help you build one https://www.youtube.com/watch?v=WybnTHDl-AM
Then build a relation between the date table and your table that has data.
then use the month from the new created date table to make a slicer on the first report, copy the slicer and put on the second report and press sync. so when you filter the Month on the first report it will automaticaly filter the second report.
Proud to be a Super User! | |
Hello,
You could build a seperate date table where you have all the dates in your data with year, month, and day columns.
check this video to help you build one https://www.youtube.com/watch?v=WybnTHDl-AM
Then build a relation between the date table and your table that has data.
then use the month from the new created date table to make a slicer on the first report, copy the slicer and put on the second report and press sync. so when you filter the Month on the first report it will automaticaly filter the second report.
Proud to be a Super User! | |
Thanks for the solution It's a very good way. I can finish my graduation project. Thank you very much. I appreciate it. 😭