Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Not converting percentages while loading data

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? ...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    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 👍

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.