Forum Discussion
Timeline slicer & variable months
I'm using this visualization and I have down pat showing "current selected" data. What I'm wondering how to do is on the same page - show the current selected time period from the slicer (say in a b...
Is there a way that I can set a dynamic date heriarchy? If I have "week" selected, I want a bar graph to show week over week what is going on. If I change it to "Month" I want to see data aggregated by month. Basically in the bar graph "Axis" I would want something that looks at slicer to determine how to set the heirarchy.
CahabaData
Memorable Member
Memorable MemberWhen your granular row value is a date - the Power BI features can expand that date into its fields for week, month, quarter values.
You can use those period values for filtering & aggregating
Any value fields of that data model can be aggregated by those periods.
so I believe you can get what you seek if I understand your question......