Change data format when live connection at power bi level

[Anonymous]

hello,

Have ssas model and power bi source is live connection ,Have one colunm  data type is decimal when showing this values on power bi for some kpis want reflects 2 decimals and some 4 decimals is it possible or how ? i have 65 kpis and decimals are not fixed some are 2 or some are 4.

kpis	values
Production Hours	46654.1111
Electricity Usage	87.88
Fuel Oil/Diesoline Usage, Lit	20.1111
Input Tonnage :	77.98
HTDB	123.7777
BIC	0.33
LC	566.99
Mill Returns	45.3

Suppose in above table some kpis like e.g Production Hours,Fuel Oil/Diesoline Usage, Lit and HTDB having 4 decimal and others are 2 decimal .

As per standard SSAS model structure, we can set on one colum either long decimal or short. but here want to set variant demial places on one column is it possible ?.
I know round function option is available but there are 60 to 70 kpis so in round have to set for one by one kpis ,any other solution plz know the possibility?

[amitchandak]

@Anonymous , in data format you can check and change the decimal place?

[Anonymous]

@amitchandak in live connection "data type","data formate" all options are disabled ,so not change directly .

[Anonymous · Accepted solution]

@Anonymous 

Try create a measure with Format(). 

Measure = FORMAT(SUM('Table'[values]),"General Number")

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.