How to apply Denomination filters for data in Bold BI Dashboards

Published:

Applying filters based denominations in Bold BI dashboards can enhance the readability and relevance of financial data. This guide will walk you through the process of setting up a dashboard parameter for currency representation and using expressions to format number columns accordingly.

Step 1: Create a Dashboard Parameter for Currency Representation

To begin, you need to create a dashboard parameter that will hold the different currency representations such as ones, thousands, lakhs, etc. This can be done by adding manual values to the parameter.

Step 2: Format Numbers Using an Expression

Once the dashboard parameter is in place, you can format the numbers by using the following expression:

[Numbers_Column1]/(IF(@{{:Representation}}='One', 1, IF(@{{:Representation}}='Thousand', 1000, IF(@{{:Representation}}='Lakh', 100000, IF(@{{:Representation}}='Crore', 10000000, 1)))))

Replace `[Numbers_Column1]` with the actual number field column from your dataset.

Step 3: Select the Desired Representation Value

With the parameter and expression set up, you can now select the desired representation value from the dashboard parameter. The number column values will automatically adjust to reflect your selection.