Last three months data as default but a slicer to view data of the prior month selected

[asheyashey]

Could we do a filter for the months for the client to select. But there should be a base filter page applied with will show 3 months.

1 have a slicer for the months(should show data beyond past three months )
2 default filter showing the past 3 months to today 

[SamWiseOwl · Accepted solution]

Hi @asheyashey 

The pre-selected slicer visual lets items be preticked so ticking everything in the last 3 months by default.
You can then use that slicer for your user or get a little creative.

Hide the pre-selected slicer and have a button that will reset the hidden slicer.
Then have a visible slicer that lets the user select anything they want (ive done it with a slicer).

[FBergamaschi]

The solution could consist into

- A slicer with the months, showing "current" for the month of today

- DAX code of a measure such that once you select any month, it shows data of that month and the previous two

Would that fit?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI