Forum Discussion
Microsoft EmployeeSwitch X Axis column through a slicer filter
Helper IIno, 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..
Solution SageWhy 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 :(
- mws5872
Hi All, I solved the process and it works just fine now. I will have to make a dummy data set later so other people can use the technique that I came up with.
- Seward12533
That woudl be AWSOME!! there are several fairly robust sample data models out there - https://docs.microsoft.com/en-us/power-bi/sample-datasets
- Seward12533
Ok, I'll monitor this thread so if you figure something out please post as the only way I have done this is a bunch of charts and bookmarks. Honestly even making 20 copies of a chart and buttons to select which one is pretty quick and easy though not elegent it works and is the only way I have yet figured out. Could do the bookmarks to switch the X axis and then use multiple tabs to handl the by Area, Product etc...
- mws5872
thanks for the input though I appreciate it. I would normally agree with you but this will become a maintnance nightmare when they are going to make adjustments to these so then I would need to do that X 20 make sense?