Page Slicer for this Month - Previous Month

[joshua1990]

Hello everybody!

I have built a huge report with several measures that shows the sales, budget, orders, etc on an MTD comparison.

Now I would like to add a slicer into the report so that the user can switch between the data for last month or this month.

How would you do that?

Is there any chance to get this done without recreating every measure with a new filter context?

[Jihwan_Kim]

Hi, @joshua1990 

Please correct me if I wrongly understood your question.

Please try to create a calculation group by using Tabular Editor in Power BI.

This will help to create a slicer for changing between current month measures VS previous month measures, or show all.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[joshua1990]

@Jihwan_Kim : I use several visuals in the page, not just a single table/ matrix.

Are you sure this will work?

[Pragati11]

Hi @joshua1990 ,

Have you tried looking into the relative date slicer:

Thanks,

Pragati

[joshua1990]

Thank you for your reply. 

I don't think this will work since we have a fiscal calendar with specific start and end dates.