Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Fernklyn
Frequent Visitor

Can I use the filters for created date and close date as the same filter?

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.

1 ACCEPTED SOLUTION
Idrissshatila
Super User
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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Idrissshatila
Super User
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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

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. 😭

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.