Forum Discussion

htaunay's avatar
htaunay
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Switch X Axis column through a slicer filter

Hi PowerBI experts,   I am currently working with a dataset where each line represents information of a specific hour, and would like to plot such data grouped by days, weeks or months, given the u...
Seward12533's avatar
Seward12533
Icon for Solution Sage rankSolution Sage
8 years ago

Try 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's avatar
mws5872
Icon for Helper II rankHelper II
8 years ago

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..