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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
serenityendy
Frequent Visitor

Create a table automatically filter by date

Hi All,

 

Any suggestion is appreciated.

 

I am trying to create a table filter by calendar date. 

Each of the page will only list out each of the calendar events based on the particular date.

So, when you click next page, it will list out the next calendar date.

 

For example,

 

Page 1

DateEvents
1/01/2019event 1
1/01/2019event 2

 

Page 2

DateEvents
2/01/2019event 1
2/01/2019event 2

 

Is it possible?

 

Many Thanks again.

1 ACCEPTED SOLUTION

The largest report i have heard of was around 250 pages, but they never hit any limit, so you might be able to make a 365 page long report, but I have no idea if Power BI can handle it, or handle to print it, or convert to PDF. 

 

If possible, i would concider making a weekly page if possible, since doing one page for each day will be incredibly time comsuming to build.

 

But concidering what you want, I would say it is possible. 🙂

 

Here is how i would do it.

I would devide the date onto 3 colums shoping Day, Month and Year, and use these as filters.

On each page i would put Day and Month on the Page level filter, and set it to the correct month and day.

 

The Year, i would filter on Report Level Filter.

 

When you are done, all you need to do for each start of the Year is to change the Year on one of the pages, and this will then affect the rest of the pages. Also by doing it this way, you will have no visible slicers.image.png

 

Hope this will help. 🙂

View solution in original post

3 REPLIES 3
CheenuSing
Community Champion
Community Champion

Hi @serenityendy ,

 

Can you load some sample data and pbix on Google / One Drive and share the link to find a solution.

 

When you say each page should show data relating to only one day of the date slicer, what is the maxmimum number of dates user will be selecting in the slicer.  This can't be totally dynamic.

 

Cheers

 

CheenuSing

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

@CheenuSing , thanks for helping up.

 

Example of the data

 

DateTimeEvents
1/01/20198.00 AMAssembly
1/01/20199:00AMMath Class
2/01/20198:00AMScience Class

 

I am trying to create a report that shows each of the events and per date on one page.

 

"When you say each page should show data relating to only one day of the date slicer," - Yes

"what is the maxmimum number of dates user will be selecting in the slicer" - this reports will show every single day in a year

And, I need to print it to be distribute.

 

Do you think is do-able?

 

many Thanks.

The largest report i have heard of was around 250 pages, but they never hit any limit, so you might be able to make a 365 page long report, but I have no idea if Power BI can handle it, or handle to print it, or convert to PDF. 

 

If possible, i would concider making a weekly page if possible, since doing one page for each day will be incredibly time comsuming to build.

 

But concidering what you want, I would say it is possible. 🙂

 

Here is how i would do it.

I would devide the date onto 3 colums shoping Day, Month and Year, and use these as filters.

On each page i would put Day and Month on the Page level filter, and set it to the correct month and day.

 

The Year, i would filter on Report Level Filter.

 

When you are done, all you need to do for each start of the Year is to change the Year on one of the pages, and this will then affect the rest of the pages. Also by doing it this way, you will have no visible slicers.image.png

 

Hope this will help. 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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