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 👍

Kishore_KVN's avatar
Kishore_KVN
Solution Sage
3 years ago

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!!