Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
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.
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
I see.
You can separate them in two columns.
or
if you don't want to separate them, you can use Format function