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

Update Report month /Qtr/ Week filter automatically

Hi All,

 

I have a report with Month ,Quarter and Weekly tabs with Month, Qurter and Week filters respectively. My report data will change based on the selected filter. My requirement is to show the report based on current Month/Qtr/Week on the initial load of report.

 

Could somebody help me on how to achieve the same.

 

My users are already subscribed to the reprots. They want to see the reprot with current Month/Qtr/Week selection by default.

Month.png

Thanks & Regards,

Rajeev 

4 REPLIES 4
Sachy123 Regular Visitor
Regular Visitor

Re: Update Report month /Qtr/ Week filter automatically

How does your Datamodel look like? Do you have a Separate Date Table?

 

rajeevbikkani Regular Visitor
Regular Visitor

Re: Update Report month /Qtr/ Week filter automatically

Hi Sachy,

 

I'm using Azure analysis service cube and it is having Date dimension table which is joined to other dimension tables.

 

Thanks & Regards,

Rajeev

Sachy123 Regular Visitor
Regular Visitor

Re: Update Report month /Qtr/ Week filter automatically

Can your client live with something like "Current Month" as a default? 

Community Support Team
Community Support Team

Re: Update Report month /Qtr/ Week filter automatically

Hi @rajeevbikkani,

 

You could create a date Slicer and change the type of Slicer to Relative Slicer. You could choose This and Week, Month, Days but there is no Quarter, you will get the data of current date. You could have a reference of the picture below.

 

Capture1.PNG

 

In Addition, if you need have the Quarter option, you could post a new idea in here.

 

Hope it can help you!

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.