Forum Discussion

Ike0911's avatar
Ike0911
Regular Visitor
2 years ago
Solved

PwerBI Changes Percentages

Hi all,  Not sure how to get around this issue with PowerBI. I'm using an excel doc with a column that has percentages in it, see below:   As you can see it normal 2 Decimal place percent...
Need Help
Tips and Tricks
  • Ike0911's avatar
    Ike0911
    2 years ago

    Hey Leandro, 
    Thank you for that information. 
    Would that need to be done on Every line?


    I"m guessing you mean on the original doc and not in Power BI??


    Because that is not feasible as there are over 18,000 Lines in the document. 

    Thanks 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ike0911 ,

 

Thanks for reaching out us. I reviewed your post and I understand that you value, such as -2.7 in excel means -2.7%. But after imported into Power BI, it displays -27%. 

The advice I can give you here is to try to see what the data type of column [PENETRATION PERCENT DIFFERENCE] is in your Power BI Desktop. If in Excel, the column is of the numeric type, in Power BI, it should be of the same data type. If you want to display the correct percentage, then you should follow LeandroDeodato 's workaround, divide the column by 100, and then say that the data format is set to percentage. Below is an example:

 

Best Regards,

Stephen Tao

 

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