topic Re: Page Slicer for this Month - Previous Month in DAX Commands and Tips

Page Slicer for this Month - Previous Month

joshua1990 — Thu, 08 Apr 2021 15:23:43 GMT

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?

Pragati11 — Thu, 08 Apr 2021 15:37:27 GMT

Have you tried looking into the relative date slicer:

Thanks,

Pragati

joshua1990 — Thu, 08 Apr 2021 16:18:51 GMT

Thank you for your reply.

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

Jihwan_Kim — Thu, 08 Apr 2021 16:29:33 GMT

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 — Thu, 08 Apr 2021 16:38:10 GMT

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

Are you sure this will work?