Forum Discussion
Date Filter and grouping problems
I am trying to create a filter that has the following options to display the data:
Date range (day, week, month, year) that would then have an option to group the data by the day, week, month or year.
So say I have 6 months data. A user would want to see the last 3 months data (first filter) but display in in weekly format. (see an average of data for that week, excluding weekends) I would like it to be a page level filter, not just an object level filter.
The dashboard I have created is ticket volumn data. with #tickets on the Y axis, Date created\resolved on the x.
Thanks for any help. I could not find the answer in the forum.
Hi jonashlock,
#1. We are not able to set chart X-axis dipslay in different date range in one level. You can try to set differnet levels in different date range use drill down feature: Drill down in a visualization in Power BI.
#2. Please check Edit Interactions in Power BI dekstop, check if the table visual is set to be filtered by the line chart.
Best Regards,
Qiuyun Yu
5 Replies
Hi jonashlock
You should have a Calender Table in your data model to group the data by day, week, month, year. Firstly create a Calender table and then create relationships between date columns in both tables.
Hi jonashlock,
Would you please share some sample data and screenshots about the desired results for our analysis?
Best Regards,
Qiuyun YuHere is a screen shot of my page
Problems i am having with my data:
- Unable to build a filter that on the X axis will allow a user to change the date range and display it by the way they want (example: Last 3 months data shown in Weekly view or Last years data shown in monthly view)
- When choosing a date point on the report type the table below sorts on that data type (open, opened today or resolved) but shows the data for the full date range selected instead of a point in time. Say I select Open on Jan 08 I would only want to see in the table the tickets that were open on Jan 08 and tagged as open today. Instead I am currently seeing all data for Open (all dates, not just the 8th)
I currently export 3 reports from our ticketing system with a report ran date time stamp. Open, Opened today, and Resolved Today. My line chart is built off of the report run date. (to be able to show workload and backlog at a point in time)
Did this help explaining the fun I am having?
