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

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 :( 

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

 

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

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

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

     

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

    ok-- I figured it out, in case others need this!!

     

    = Table.AddColumn(#"Renamed Columns", "Custom.1", each Text.From(Date.Year([Measure]))&"-"&Text.From(Date.Month([Measure]))) 

     

    BOOM DONE.

     

    I will keep you updated on final solution.