Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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. 😭
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |