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

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)

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