Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Intelligent number formatting & scaling in Power BI

by Inforiver | May 20, 2021 | ,

Inforiver for Power BI comes prepackaged with intelligent number formatting & scaling recognition capabilities that help display data in a perceptive manner in your table / matrix style reports right out of the box. The in-built intelligence does the hard work so that you do not have to.

Let us take a sample dataset as shown below. You can immediately spot data of mixed granularity – with values in millions, thousands, and even one that is just a few dollars’ worth.

Intelligent & Automated Number Formatting for Tables

Let us see how Inforiver handles such a dataset of varying granularities & formats.

1. Measure-level formatting and scaling

When you load this data, Inforiver scales each measure individually by default (and the scaling for each measure is shown in the column header). This is useful to show measures of varying granularities (e.g., Revenue & Quantity) in the same table.

Measure-level formatting

You can change this behavior by using the number formatting pane on the menu. You may select a 'number formatting theme' from the dropdown and customize it further using the icons shown right beneath the dropdown.

Number formatting theme

When you expand the dropdown, you see several options.

Quick format dropdown

Let's observe what happens when we change this selection.

2. Uniform number formatting and scaling

When you change the format from the default 'Measure level' to 'Uniform', Inforiver applies one fixed scale to the entire table, and moves the scaling unit display to the header. In addition, the number of decimals is reduced to one for better readability.

Uniform number formatting

When you expand the dropdown again and click on the arrow next to Uniform, you can see there are more options as shown in the image. By default, auto formatting has been applied. But you can change it to thousands, millions or so on as needed. 

Uniform number formatting

3. Auto number formatting and scaling

Go back to the dropdown and change the format to 'Auto'. This auto formatting is a big favorite for many as it allows each cell to have its own scaling. Check this out. Notice how World Tour In Style is scaled to millions while Phone call is not scaled at all. 

Auto number formatting

4. Native number formatting

If you do not want any fancy formatting and need the numbers just as they are in the source data, select the ‘Native’ option. 

Native number formatting

Other characteristics of Inforiver number formatting & scaling

Inforiver uses a monospace font (Inforiver Sans). This means all the scaling units such as ‘k’ and ‘m’ (for thousands and millions respectively) occupy uniform width. Most standard fonts such as Arial, Times New Roman, Segoe UI and Open Sans are not monospace fonts. Using such fonts will not deliver uniform alignment of decimals.

Inforiver number formatting

In fact, Inforiver also leaves some space on the right for unscaled values (see the last row below). This ensures that the decimal point is perfectly aligned for all the rows.

Inforiver number formatting

And what more, Inforiver also shows the unscaled values in the tooltip (available upon publishing to service). This helps you scale values without losing the ability to look up the unscaled value whenever required.

Unscaled values in the tooltip

You may choose one of the four options, and continue to fine-tune the format at a row, column/measure or cell-level using the icons just below the dropdown. These options include conversion to % format, attaching prefix/suffix, and increasing/decreasing decimal spaces. 

Intelligent & Automated Number Formatting for Tables

Check out this example where we have used the custom options above to change the formats of specific cells. (These actions can also be performed for individual rows or columns/measures)

Intelligent & Automated Number Formatting for Tables

Number formatting with Inforiver is much quicker and a lot of fun. It is available in all Inforiver editions. Go ahead & try it out directly from Microsoft Appsource today! 

Watch a quick demo of Inforiver's number formatting and scaling capabilities for table / matrix style reports in Power BI.

Intelligent number formatting & scaling in Power BI

Inforiver Logo
IBCS Certified
Power BI certified
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
5920 Windhaven Pkwy, #130
Plano TX 75093
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram