Forum Discussion

BenWatt's avatar
BenWatt
Frequent Visitor
9 years ago
Solved

Dynamic Period slicer

I'm sure I've seen this, but can't track it down.

 

I'm looking to put a slicer on a report with options YTD, LastMonth, Last 3 months. I would like this to filter the date dimension according to the formula for each one. Is this possible?

 

as FYI, I've already got relative date logic in to flag each month as "Current Period", "Current Period -1", etc but users want a quicker way to swap between the common filter scenarios.

 

thanks

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi BenWatt,

     

    You should be able to follow this excellent article which describes how to create Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M to get your expected result. :smileyhappy:

     

    Regards

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi BenWatt,

     

    You should be able to follow this excellent article which describes how to create Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M to get your expected result. :smileyhappy:

     

    Regards