Forum Discussion
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
| Date | Events |
| 1/01/2019 | event 1 |
| 1/01/2019 | event 2 |
Page 2
| Date | Events |
| 2/01/2019 | event 1 |
| 2/01/2019 | event 2 |
Is it possible?
Many Thanks again.
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.
Hope this will help. :-)
3 Replies
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
Anonymous , thanks for helping up.
Example of the data
Date Time Events 1/01/2019 8.00 AM Assembly 1/01/2019 9:00AM Math Class 2/01/2019 8:00AM Science 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.
Hope this will help. :-)
