cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StevesHelp Regular Visitor
Regular Visitor

Test

 
3 REPLIES 3
Super User
Super User

Re: Multiple Time Filters on One Report

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


StevesHelp Regular Visitor
Regular Visitor

Test

 
Moderator Eric_Zhang
Moderator

Re: Multiple Time Filters on One Report


@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)

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 111 members 1,486 guests
Please welcome our newest community members: