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

Why not just teach people how to use drill down capability of the charts and matricies to switch what is displayed? 

 

 

 

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

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

    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. 

     

     

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

        I will check that out, I am also working on dynamic labeling right now-- didnt see much out there.... but maybe its not possible?

  • 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)

         

         

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

      so, almost there I have everything working except quarters. Does anyone know the proper way to use the M(Power Query Lanagugage) to do something like this equivilant in excel/PBI Measures ? 

       

      Quarter 

      DateFormat = year('Quarter Dates'[DateValue])&"-Q"&ROUNDUP(MONTH('Quarter Dates'[DateValue])/3,0)

       

      Month

      Dateformat =year('Quarter Dates'[DateValue])&"-"&MONTH('month Dates'[DateValue])

       

      I have not been able to find this out yet.

       

      • Seward12533's avatar
        Seward12533
        Icon for Solution Sage rankSolution Sage
        8 years ago

        Date.QuarterOfYear([Registration Date]), Int64.Type)