What if Parameters with Billions

[Anonymous]

I was wondering if the "What if Parameters' support Measures to the Billion values?

I have a table which has a column which can sum together into the $10 Billions value. I want to have a "What if Parameter" that allows a user to utilise the slicer to move between the Billions.

The issue is that the What-IF parameter only allows up to 1 Billion. Even settign a minimum of 100 Mil for example and incrementing it in the 100 mil, doesn't allow Parameter sto be created.

Any alternatives?

An alternative, I've thought about creating an additional column to DIVIDE, but as I utilise Cards, they will show up as M instead of the bn (billion).

For example,

Currently Row 1: 1500000000

Using DIVIDE(1500000000,1000) = 1500000

This will display as 1.5M instead of 1.5bn. Any way I can format the data to scale the 1500000 to display as Bn, whilsts still retaining its number format?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please create a calculated table like that to work around.

Table 2 = 
ADDCOLUMNS (
    GENERATESERIES ( 1000000000, 10000000000, 500000000 ),
    "a", [Value] / 1000000000 & "bn"
)

[danextian]

Hi @Anonymous 

I've just tested myself using GENERATESERIES() function and New Paramters and inputting billions worked fine.  Here's a sample pbix

https://drive.google.com/file/d/1WymBao5SEYcRQ3kpSjoVfLvvgt_b3pAW/view?usp=sharing 

[Anonymous]

Interesting.. it works when using the GENERATESERIES instead of through the Modelling.

In that case, I'm wondering if there's a way to make a Parameter Input more user-friendly. Is there a way to display on the Parameter Slicer, a billion value in a way similar to how it is displayed in cards, e.g. 1.5Bn etc.

[danextian]

You may try using thousands instead of billions/millions in your parameter. If you start using 1.5Bn, that won't be a number input but a text. The New Parameter function uses GENERATESERIES() which supports numbers only.