Format numbers to thousands / millions in multi row card visual

[shaunmag]

I have a multi-row card, that shows a range of numerical values ranging from 10 up to 10 million.

I would like to format each individual value to be shown in the most appropriate unit (thousands / millions etc), depending on its value.

In the Format > Data Labels pane, there is no option to do this.

Does anyone have any idea how I can get around this?

Thanks

[v-alq-msft · Accepted solution]

Hi, @shaunmag 

Based on your description, I created data to reproduce your scenario.

Table(a calculated table):

Table = GENERATESERIES(10,100000000,1)

You may create a measure like below.

FormatedValue = 
var _value = SELECTEDVALUE('Table'[Value])
return
SWITCH(
    TRUE(),
    _value>=10&&_value<=99,(_value/10)&" ten digits",
    _value>=100&&_value<=999,(_value/100)&" hundreds",
    _value>=1000&&_value<=999999,(_value/1000)&" thousands",
    _value>=1000000,(_value/1000000)&" millions",
    _value
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This solution worked fine. But is there a way we can have something similar in pie charts?

[amitchandak]

@shaunmag ,

Refer: https://community.powerbi.com/t5/Desktop/measure-for-converting-numbers-to-million/td-p/589524

You can use Data format at Visual level

[EmiliaB_123]

HI @amitchandak ,

where is this functionality in the new format pane? I can´t find it.

[parry2k]

@shaunmag in multi row card you don't have the option to set display units, you need to pre-format your values before using in this visual.

Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com