Test

[Eric_Zhang]

---

@StevesHelp wrote:

Hello all,

I have my report completely made with the last task making a time filter.

I want to create a dual time filter where the end user can select one of two options for (1) Prior Fiscal month or (2) Rolling 12 months.

I already have these columns calculated and verified they are working correctly. 

I just want the end user to be able to select one of these time filters and the reports adjust to that time frame.

Is this possible without having them to move the Date slicer left/right? I just want them to be able to point and click to filter.

---

@StevesHelp

To make the slicer work, you may create an auxilary table with one column which has values "Prior Fiscal Month" and "Rolling 12 months". And then create a measure as

measure = if(max(auxilaryTable[column])="Prior Fiscal Month",measurePFM,measureRoll12)

[Greg_Deckler]

I think what I would do in this case would be to use Bookmarks feature and tie an image to your bookmarks as a toggle.