How to Isolate Weekdays in Power BI Query

Updated on:

April 6, 2026

By:

Madhav Bhandari

Use this interactive demo to learn how to isolate weekdays in your Power BI reports.

‍

Here’s how to do it:

‍

Start by clicking the 'Transform data' button in your 'Home' tab.
This opens the Power Query Editor. Navigate to the 'Add Column' tab in the ribbon.
Click on the date column you want to extract weekdays from.
In the 'Add Column' tab, find and click on the 'Date' option.
From the dropdown menu that appears, select 'Day'.
Then choose 'Day of week'. This adds a new column showing the day number.
Now, click the filter dropdown arrow on your new 'Day of Week' column.
Time to banish the weekend! Uncheck the values for Saturday (6) and Sunday (0).
Click 'OK' to apply your filter and show only weekdays.
Click on the 'File' menu in the top-left corner.
Select 'Close & Apply' to save your changes and return to Power BI.
That's it! You've just isolated weekdays in your dataset using Power Query.

📌 Why this matters

Business reporting rarely needs weekend data cluttering your analysis. By filtering to weekdays only, you create cleaner trend lines, more accurate performance metrics, and reports that align with actual business operations.

Your sales forecasts become more reliable when they're based on the five days that matter most. This filtering also speeds up data processing and makes your dashboards more responsive, since you're working with roughly 30% less data while maintaining all the insights that drive business decisions.

Your product deserves an interactive demo

Start free

How to Uninstall Power BI

How to Compare Two Measures in Power BI

How to Compare Months in Power BI