Forum Discussion

Zwitter's avatar
Zwitter
New Member
2 years ago

Convert properly to percentages

Hi.

 

Not sure why this is so hard. Cannot get the percentages to show up in any graph. It's either all 100% or 1, even though none of the dataset includes these numbers. Converting the table data to a graph resets all the score percentages to 1. I really wonder how this is meant to be either intuitive or useful.

 

Unadulterated data

Need Help

5 Replies

  • ZhangKun's avatar
    ZhangKun
    Super User
    2 years ago

    It's very important —— the text is left, the number is right. Two data column are text type, you must convert to datatime type, number type.

  • homerlee57's avatar
    homerlee57
    New Member
    2 years ago

    Converted to Dates and decimal numbers. Problem persists. Power Bi is unable to convert the decimals to percentages. Converting in Query Editor is of no help.

     

    Would anyone happen to ahve a solution? Considering how many questions are asked about this issue, you'd think they would have implemented a solution by now,

     

  • PwerQueryKees's avatar
    PwerQueryKees
    Super User
    2 years ago

    You are doing a count of score percentage. Try and average of score percentage....

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Zwitter ,

     

    Insights from everyone are all great.

    I want to share how to display percentage format in detail.

    Create a calculated column to divide by 100.

    percentage = [score_percentage]/100

    Then click "%" button to display percentage.

     

     

    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.