How to Convert the values of a row into percentage based on condition inline chart and table

[infantpowerbi]

Dear All,

I am from tableau background and struggling to make this happen lack of knowledge in DAX.

I am having the data in below format

After Importing data in Power BI table , Application  Apple values changes the format and looks like below

Can any one please help me in knowing how can I change the application Apple value into percentage in line chart and in table.
For refrence please refer the below link

https://www.mediafire.com/folder/kgi5db04eswkv/

Note: strictly not allowed to create new columns

[Ashish_Mathur]

Hi,

My suggestion would be to transform the data such that we create 2 columns - one for Android and another for Apple.  This way we will be able to specify different formats for the 2 columns.  Would you be agreeable to this transformation.

[mussaenda]

Hi @infantpowerbi ,

after checking the file you attached, I noticed that on your data type is Whole Number.

Also, make the column of your Value in excel a number.

Then set the Value datatype in power bi to decimal number also.

[infantpowerbi]

Here the challenge is that Android values should remain in numeric and iphone vlaue should remain decimal in Power BI table or in line chart

[mussaenda]

I see.

You can separate them in two columns.

or

if you don't want to separate them, you can use Format function