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

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

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?

 

  • mws5872's avatar
    mws5872
    Icon for Helper II rankHelper II
    8 years ago

    another idea I had was creating dynamic labeling if that was possible. this then would cut it to a 5 charts regardless ( just for the date options)