How to Filter by Month in Power BI



Guide

  1. Open your Power BI desktop and navigate to the report where you want to implement month filtering.

  2. In the 'Visualizations' pane on the right side, locate and click on the 'Slicer' visual icon to add a new slicer to your report.

  3. Find your date field in the 'Fields' pane and drag it into the empty slicer you created. This will be our month filter.

  4. Under the 'Date' field, select 'Month'.

  5. Now you can filter your report data by selecting specific months. All your visualizations will update automatically to show only the data from your selected month(s).

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline