How to Fix Incorrect Date Sequencing in Bold BI's Pivot Grid (Weekly / Custom Date Format)
When working with Pivot Grid widgets in Bold BI, date fields grouped by weekly or custom formats (e.g., WeekYear) may sometimes appear out of chronological order, even after applying sorting options.
This article explains the root cause and provides a clear solution to ensure proper date sequencing.
Problem Description
- You may encounter the following behavior:
- Date values (e.g., weekly format) are not displayed sequentially
- Sorting options like Ascending / Descending do not work
- Issue persists even when date field is correctly placed in the Columns section
- This typically occurs when using:
- Weekly grouping formats
- Custom date formats such as WeekYear
Cause
- Pivot Grid applies sorting based on hierarchical precedence: (Row sorting takes priority over column sorting)
- If row fields are sorted using Alphabetical order (or other options), they override column-level sorting, causing incorrect date sequences.
Fix: Update Row Sorting Configuration
Follow these steps to correct the issue:
Step 1: Open the Dashboard in Edit mode
- Navigate to the dashboard containing the Pivot Grid
- Click Edit to open it in Bold BI Dashboard Designer.
Step 2: Access Pivot Grid Settings
- Click the Pivot Grid widget on the canvas.
- Open the widget Settings / Configuration panel (right-side properties panel).
Step 3: Modify Row Sorting
- In the Pivot Grid field layout, locate the Rows section.
- For the row dimension field(s), click the Settings icon.
- Open Sort (Advanced Sorting options).
- Set sorting to Data Source Order and click Apply.
Why this works: Pivot Grid sorting follows hierarchy precedence. If a Row field is sorted alphabetically (or by another rule), it can override the intended chronological ordering of the Column headers.
Step 4: Verify the date field placement and column sorting
- Confirm your weekly/WeekYear date field is placed under Columns.
- If needed, open the Column field Sort settings and set the expected order (Ascending/Descending) after Row sorting is corrected.
Save and republish
- Click Save.
- Publish (or republish) the dashboard.
Expected Result
- Date values will now appear in correct chronological order
- Column sorting will function as expected
- Weekly or custom date formats will display properly
Key Notes
- Ensure the date field is placed in the Columns section
- Always verify row sorting settings when facing sorting issues
- Avoid mixing conflicting sorting configurations between rows and columns
- Use Data Source Order when working with time-based data
Conclusion
Incorrect date sequencing in Pivot Grid is primarily caused by sorting precedence, not the date format itself.
By updating the row sorting to Data Source Order, you allow column-level sorting to function correctly, ensuring accurate and predictable date sequencing.
Related Articles
