Forum Discussion
Solved
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...
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
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.