Forum Discussion
Microsoft EmployeeSwitch X Axis column through a slicer filter
Helper IIOwenAuger Thanks for this idea it works very well except in the situation I ran into. you can see my post below. thanks for this !
Solution SageTry using multiple charts that you selectively show/hide with bookmarks and selection pane and use buttons to switch between them. I use this method extensively.
So you woudl have 5 version of the chart and create bookmarks with only one of these shown. Then create buttons linked to those bookmarks. (tip when saving bookmark be sure to uncheck the data propery of the bookmark so it only remembers which visuals to display and does not reset any filters.
- mws5872
no, because the next step is to include charts with dynamic labels if that make sense. say breakdown by products on the label or by regions on the labels. so then it would be 5 X the number of breakdowns. so just for those two I mentioned I would need 10 charts....
5 for the dates X 2 diferent types ( I am planning more than 2.... probably 8 different mix types..
- Seward12533
Why not just teach people how to use drill down capability of the charts and matricies to switch what is displayed?
- mws5872
again, no that is not going to work. The users want to use buttons. I know this is possible for sure but I am unsure how to approach this and I have literally been banging my head against the wall all day :(