Hi All,
I have a "slicer" that is connected to a Calendar table with "Date Hierarchy" like this
"[Calendar].[Date Hierarchy].[Week]"
"[Calendar].[Date Hierarchy].[Month]"
"[Calendar].[Date Hierarchy].[Year]"
What I would like to do know is change the level of slicer to correspond to changes made by user.
Ex. User presses "monthly" button - the pivot table/chart drills to selected level - her I would like to have the slicer to follow that order.
i.e. when the data is drilled to "daily level" the slicer is on same level - I prefer to have only one slicer visible
Any ideas how to do that without deleting an re-creating the slicer?
I have a "slicer" that is connected to a Calendar table with "Date Hierarchy" like this
"[Calendar].[Date Hierarchy].[Week]"
"[Calendar].[Date Hierarchy].[Month]"
"[Calendar].[Date Hierarchy].[Year]"
What I would like to do know is change the level of slicer to correspond to changes made by user.
Ex. User presses "monthly" button - the pivot table/chart drills to selected level - her I would like to have the slicer to follow that order.
i.e. when the data is drilled to "daily level" the slicer is on same level - I prefer to have only one slicer visible
Any ideas how to do that without deleting an re-creating the slicer?
