Customizing the Start Day of the Week in Bold BI

Published:

Introduction

This guide outlines the steps required to customize the start day of the week in the relative date filter, Expression, and Widget Aggregation using the Data language option in the language settings.

Steps to Customize Start Day of Week

I. Relative Date Filter

Step 1: Set Language

Navigate to the site settings.
Choose English (United Kingdom) for Monday or English (United States) for Sunday as the start day of the week.
Every language setting will reflect the cultural norm for the starting day of the week.
Save the changes and refresh the application in order to apply the new language settings.

Step 2: Create a Data Source

Establish a data source within your application.
Add a grid widget to your workspace.
Drag the Date field into the Column Box of the grid widget.
Click on ‘Week of Year’ and choose the relative date filter option.

Step 3: Configure Relative Date Filter

In the Range Box, select Week.
In the Period Box, choose Current Week.

For Monday’s configuration:

For Sunday configuration:

Step 4: Result

For Monday configuration, the grid widget will display the date range from Monday to Sunday (e.g., 29/01/2024 to 04/02/2024)
For Sunday configuration, the grid widget will show the date range from Sunday to Saturday (e.g., 01/28/2024 to 02/03/2024).

II. In Expression

Step 1: Set Language

Follow the same language setting steps as outlined in the previous sections.

Step 2: Create a Data Source with an Expression

Establish a data source within your application.
Add an Expression of DATEPART (WEEK, [Date]).
Note: Use DATENAME (WEEK, [DATE]) in some plugins.
Save and preview the table for Monday – English (United Kingdom).

Step 3: Reset the Language and Preview

Change the Language to the appropriate setting and save.
Refresh the application to apply the new language settings.
Re-save the existing expression with a DATEPART week and preview the table for Sunday – English (United States).