How to Filter Weekdays Using Queries in Power BI
- George Apostolov
How to Filter Weekdays Using Queries in Power BI: step-by-step guide
Go to the 'Transform data' from your 'Home' tab.
Select 'Transform data' to open the Power Query Editor.
Go to 'Add Column'.
Select the date column.
Under the 'Add Column', select 'Date'.
From the menu, select 'Day'.
Once you have selected the 'Day', choose 'Day of week'.
Click on the drop-down arrow to filter the weekdays.
Uncheck the numbers for Sunday and Saturday.
Once done, click 'OK'.
Click the 'File' menu.
Select 'Close & Apply' to save changes.
Following these steps can help you easily filter weekdays using Power BI queries.
Quick answer: To filter weekdays using Power Query Editor in Power BI, open Transform data from the Home tab, add a Day of week column, filter out Sunday and Saturday, and select Close and Apply from the File menu.
About this Power BI tutorial
Exclude weekends from your data by adding a day of week column and filtering weekdays within Power BI queries. This guide shows how to filter Weekdays Using Queries in Power BI in 13 steps, starting with "Go to the 'Transform data' from your 'Home' tab" and finishing with "Following these steps can help you easily filter weekdays using Power BI queries". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to filter Weekdays Using Queries in Power BI?
13 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Power BI. Related guides: How to Format a Column in Power BI, How to Format a Number in Power BI and How to Format Data in Power BI. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
