Forum Discussion
Timeline slicer & variable months
I believe one cannot put the cart in front of the horse - or in this case the slicer in front of the calculation - - - sorry for bad joke.....
In your data model where you now have value 'X' - you want also a measure/column along side with value 'X-prior year' (or whichever period). So that X and X-prior are side by side values. Then if you filter on X the X-prior value is available to you.
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.
When 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......