Number Formatting

Supported in: ✔️Date Filter ✔️Facet Filter ✔️Hierarchy Filter ✔️Alpha Numeric Filter

✔️Numeric Filter

The Number Formatting Configuration feature allows users to customize how numerical values are displayed in the visual.

How to Configure Number Formatting

1. Decimal Separator: Use the provided text box to specify the character for the decimal separator (e.g., . or ,).

2. Thousand Separator: Enter the character for the thousand separators in the text box (e.g., , or a space).

3. Value Decimal Places: Adjust the number of decimal places by typing a value or using the up/down arrows in the box provided.

4. Scaling Display: Select how numbers are scaled from the dropdown list. Options include:

   • Auto: Automatically scales numbers based on their size.

   • None: Displays the full value without scaling.

   • Thousand: Scales values to thousands (e.g., 1,000 → 1K).

   • Million: Scales values to millions (e.g., 1,000,000 → 1M).

   • Billion: Scales values to billions (e.g., 1,000,000,000 → 1B).

   • Trillion: Scales values to trillions (e.g., 1,000,000,000,000 → 1T).

5. Prefix: Add a prefix to numbers (e.g., $, €) using the text box provided.

6. Suffix: Enter a suffix for numbers (e.g., %, units) in the text box.

7. Customize Scaling Labels:

   • Enable the Customize Scaling Label toggle to define custom labels for scaling options.

   • Text boxes for Thousand, Million, Billion, and Trillion appear, allowing you to input custom labels (e.g., "K" for thousand, "Mln" for million).

Image 1: Number Formatting Settings in Format pane

Dynamic Format String Measure Support

Super Filter now provides support for dynamic format string measure within the visual. This feature allows you to apply custom formatting conditions defined in a measure, offering greater flexibility and precision in displaying data.

Steps to Enable and Use:

1. Define a measure with custom formatting conditions in Power BI. For additional guidance, review the official documentation: Create dynamic format strings for measures in Power BI Desktop.

2. Insert the format string measure into the "Others" section of the Super Filter visual.

3. Turn off the default number formatting option in the visual settings. The visual will now display data according to the formatting conditions defined in the measure.