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 👍

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
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 👍