Not converting percentages while loading data

[Anonymous]

I have this following table as my input file to powerBI that has both decimals and percentages in a field:

Is there a way to bring this up without converting everything to decimal in powerBI?

Right now, everything converts to decimal without making any transformations. I dont want to change all the values to percentages.

[v-rzhou-msft]

Hi @Anonymous ,

As far as I know, Power BI is calculated based on columns, so there will be only one data type/data format in each column. 

So when you load the data with percentage type or decimal number type into Power BI, there will be only decimal number type on this column.

You can try FORMAT() function as their suggestions. However, your column will be convert to text type due to this function.

Best Regards,
Rico Zhou

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

[DOLEARY85 · Accepted solution]

Hi,

try this measure, essentially you need to select the KPI to link the associated format to it:

Value Measure For Multiple Data Formats = IF(OR(CONTAINSSTRING(SELECTEDVALUE('Table (2)'[KPI]),"X"),CONTAINSSTRING(SELECTEDVALUE('Table (2)'[KPI]),"Z")),FORMAT(SUM('Table (2)'[Values]),"#%"),FORMAT(SUM('Table (2)'[Values]),"0.00"))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Kishore_KVN]

Hello @Anonymous create a new column and its calculation looks as below:

If(KPI = "Z', FORMAT('TABLE'[VALUES],"0%"), 'TABLE'[VALUES])

this will create new column and only Z will be converted not all others. 

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