Forum Discussion

pantherfanrh's avatar
pantherfanrh
Frequent Visitor
9 years ago
Solved

Making a slicer or graph display X months back

Hi all!   I am trying to use Power BI to display a report that will show me the past X number of months from the point that I click. For instance, If I click Jan, 2016 in the slicer, it will displa...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi pantherfanrh,

     

    I'd like to suggest you add a calculate column to show the diff between current row and today. After create the column, you can  use this as the source of slicer(switch the mode to "Less than or equal to")

     

    Calculated column formula:

     

    Diff = DATEDIFF([Date],TODAY(),MONTH)

     

    Notice: you should turn on the preview feature "number range slicer" to enable the expand options.

     

     

    Regards,

    Xiaoxin Sheng

pantherfanrh's avatar
pantherfanrh
Frequent Visitor
9 years ago

So something like

 

date=EDATE([workdate],13)

 

then set the filter to that measure?

 

I'm trying to use EDATE but it doesn't like it when I use my column of dates in the table. Any advice?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi pantherfanrh,

 

I'd like to suggest you add a calculate column to show the diff between current row and today. After create the column, you can  use this as the source of slicer(switch the mode to "Less than or equal to")

 

Calculated column formula:

 

Diff = DATEDIFF([Date],TODAY(),MONTH)

 

Notice: you should turn on the preview feature "number range slicer" to enable the expand options.

 

 

Regards,

Xiaoxin Sheng

  • pantherfanrh's avatar
    pantherfanrh
    Frequent Visitor
    9 years ago

    Thank you so much!