Forum Discussion

Jay2022's avatar
Jay2022
Icon for Helper IV rankHelper IV
1 year ago
Solved

100 showing as 1

I am trying to create a pie chart based out of ranges 

0-25%

25-50% etc 

however when I pull the data through 100% comes up as 1 

 

The ony solution i could find was to put '   ' around the 100% in the orginal data sheet. 

 

Can anyone help with this ?

 

 

Need Help
Show and Tell
Tips and Tricks
  • Anand24's avatar
    Anand24
    1 year ago

    Hi Jay2022 ,
    You can solve this by any of the below 2 methods:
    1. Change the format of your field to percentage (Preferred)



    2. Create a calculated column using DAX or create a new column from Power Query Editor which multiplies your numeric field to 100. (Not preferred since it will just increase the dataset size unnecesarily)

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn

5 Replies

  • freginier's avatar
    freginier
    Icon for Solution Sage rankSolution Sage
    1 year ago

    Hi there!

     

    Your 100% showing as 1 issue is likely caused by Power BI interpreting percentages as decimal values. In Power BI, percentages are stored as decimal numbers (e.g., 100% is stored as 1.0).If your original dataset contains 100%, it is being read as 1 (since 100% = 1 in decimal form).When displayed in a visual without formatting, 1 appears instead of 100%.

    You should go to data view and see what needs to be formatted. 

    If the values are stored in decimal format (e.g., 1 for 100%), you can create a calculated column in DAX:

    Percentage_Display = Table[YourColumn] * 100 (Use this column in visuals where you need 100 instead of 1.)

     

    Hope this helps!

    😁😁

     

  • Anand24's avatar
    Anand24
    Icon for Super User rankSuper User
    1 year ago

    Hi Jay2022 ,
    You can solve this by any of the below 2 methods:
    1. Change the format of your field to percentage (Preferred)



    2. Create a calculated column using DAX or create a new column from Power Query Editor which multiplies your numeric field to 100. (Not preferred since it will just increase the dataset size unnecesarily)

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
  • Jay2022's avatar
    Jay2022
    Icon for Helper IV rankHelper IV
    1 year ago

    My format is general not percentage since my other options are 20-50%, 50-75% etc 

     

    • Anand24's avatar
      Anand24
      Icon for Super User rankSuper User
      1 year ago

      Jay2022 - Can you please provide your sample data, output currently being received and expected output?

      • v-aatheeque's avatar
        v-aatheeque
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi Jay2022 

        Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.

        Should you have any further questions, feel free to reach out.
        Thank you for being a part of the Microsoft Fabric Community Forum!