Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. 😭
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |