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

OwenAuger Thanks for this idea it works very well except in the situation I ran into. you can see my post below. thanks for this !

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.