Custom format in Power BI - not text, but sum

[eagleae]

Hi all,

I have a table with individual format for each parametr - percent, abs. value, etc.

I made the formula for it, but when i transfer it to the graph, Power BI displays me only quantity, not sum in values.

How can i transfer this column for Power BI to recognize it like sum, not text? Because when i choose "value" in setting he returns error

Thanks

Value_format = if('17 KPI online (2)'[KPI]="CR Mobile",format('17 KPI online (2)'[Value],"0.00%"),if('17 KPI online (2)'[KPI]="ac",format('17 KPI online (2)'[Value],"0.00%"),if('17 KPI online (2)'[KPI]="vip",format('17 KPI online (2)'[Value],"0,#0"), if(or('17 KPI online (2)'[KPI]="nps",'17 KPI online (2)'[KPI]="usability"),format('17 KPI online (2)'[Value],"0.0"),format('17 KPI online (2)'[Value],"0.00")))))

[eagleae]

ok, but it will be the whole format for every parametr, but i need different..

[PhilipTreacy · Accepted solution]

@eagleae 

Try creating different measures for each parameter/format you need.  Looks like you only need 2 or 3 different ones?

Regards

Phil

[eagleae]

yes, thanks, it is a good idea

[PhilipTreacy]

Hi @eagleae 

In Report View, on the Ribbon, choose the Format, or type in your own custom format

Regards

Phil

[eagleae]

Thanks, Philip. But i can't find..where i can make a custom format for each perimetr in format area?

[PhilipTreacy]

Hi @eagleae 

The FORMAT function creates a text string so if you try to use that in a chart, you can't SUM a text value, so the chart displays the Count..

If you want a SUM you need to be plotting numeric values in the chart.

Regards

Phil

[eagleae]

Thanks! So I can't  solve this problem...? 

Don't in Power bi have possibility to put different formats in graphs?

[PhilipTreacy]

Hi @eagleae 

Yes you can display numeric/date values in different formats but you are creating strings by using the FORMAT function.  You can't SUM a string or do maths with it so you can't display it in any other way than the count of that string.

You should just chart 17 KPI online (2)'[Value] and then apply a format to those values from the Format area of the Ribbon.

Regards

Phil