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

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!