Forum Discussion
Dynamic Filter Propagation
Hi petersi,
I can prepare this datasets statically. I.E. with specific groupings on the originatiing source data on the SessionTime field. I.E. a dataset grouped on a
- day basis
- week basis
- month basis
- year basis
What I am trying to achieve is have only one dataset with the raw data and group it dynamically where the user can select what grouping they want to view in, i.e. day,week,month,year.
If I understand you correctly, I don't think there is an easy way to do it currently.
When you add a date field to a visual in the Axis field bucket, Power BI automatically adds a time hierarchy that includes Year, Quarter, Month and Day. By doing this, Power BI allows your visuals to have time-based interaction with those viewing your reports, by letting users drill-down through those different time levels.
I would suggest you try visualizing your data with the drill down feature to see if it can give you the expected result.
Regards
I am using the drill down option currently. Just see that there are issues that I'm not sure how to resolve. I am specifically displaying the data in the following groups on a date field:
day
month
week
year
The grouping operations are being done via a SQL query operatrion. So I have a resultant 4 datasets on these specific groupings. When I put these datasets into a single graph it always shows bars for all groups even though it is only showing one group at a time. Also the expand all option is not usable in this scenario as there is no relation between the datasets being used. The resultant char looks like the following:
I only want the chart to show the data for the associated group (i.e. x axis) selected. Also, is there a way to disable the expand all option -- expand down one is fine beause I need to see all datasets.