Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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
Hi @jonashlock,
Would you please share some sample data and screenshots about the desired results for our analysis?
Best Regards,
Qiuyun Yu
Here is a screen shot of my page
Problems i am having with my data:
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?
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
Have you considered using a slicer? I have had a similar problem to this in the past and was able to use a slicer in conjuction with a new column spilt off from the main date/time group. Just a thought.
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |