How can I sort integers in Bold BI

In Bold BI, sorting functionality is limited to dimension columns. This article explains how to sort grid columns in Bold BI and provides a workaround for sorting columns containing integer values. By converting the measure column to a dimension column using a custom expression, you can enable sorting for integer-type data.

For MSSQL connections, use the following expression to convert the measure column to a dimension column:

CONVERT(varchar(10),[Column_name])

For PostgreSQL connections, use the following expression to convert the measure column to a dimension column:

CAST([Column_name] AS VARCHAR)

Follow these steps to configure the custom expression:

1. Open the Data Source window.
2. Navigate to the Expression designer and click on the Add button to create a new expression.
3. Enter the expression CAST([Column_name] AS VARCHAR) in the expression editor, replacing [Column_name] with the name of your integer column.
4. Save the custom expression.
   
   

Now, you can use the sorting functionality on the newly created dimension column in your grid.

Additional References

• Advanced Sorting
• Configure Expression Columns