Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

Enquiry an incorrect data column

The user has combine all data in one column including numbers and percentages. In the bar chart, it has displayed the percentage correctly. However, when i hover the chart, the percentage is multiple by 100. eg 80% become 8000%. 

 

I have attempted to create another column with %, the problem still persist. Is there a quick fix that I can use?

 

Is format code a solution?

 

 

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 months ago

    My quick solution is just to turn off the tooltip. In this way, the user will not see the incorrect value without making the case too complicated. (It is very oddward it the presenter/enduser see that as this does not add any value in the result)

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 months ago

    My quick solution is just to turn off the tooltip. In this way, the user will not see the incorrect value without making the case too complicated. (It is very oddward it the presenter/enduser see that as this does not add any value in the result)

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 months ago

    Many thanks for all the contributions. 

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    8 months ago

    Hello Anonymous 

     

    try this dax for calculated column

    PercentageValue =
    VAR CleanValue = SUBSTITUTE([YourColumn],"%","")
    RETURN VALUE(CleanValue)/100

     


    If my response helped you, please consider clicking
    Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


    Thanks,


    Connect with me on:

    LinkedIn

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 months ago

      IN the matrix table, power bi display the value correctly. However, the chart becomes decimal. 

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 months ago

        in the calculated column, here is the format "#.#"%"

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    8 months ago

    Anonymous 

     

    Looks like your Value column is rounded?  Are the percentages created from the Value column?

     

    If so, just divide the Value by 100, the result being a decimal. 

     

    Percentage = [Value] /100

     

     

    Percentages are stored as decimals in PBI, they are just displayed as a % by selectign the column and clickin the % symbol in the Formatting area

     

     

     

     

    Regards

     

    Phil

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 months ago

      If i do that, the % when I hover the chart is correct, but the chart values display are not correct. I guess this may be due to the format used in the same column. 

      Newcolumn = Data[Value]/100
  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    8 months ago

    Anonymous 

     

    Convert your percentage column to a decimal number

    Format the column as Percentage in the Modeling tab - no format code needed

     

    If it’s a measure, use DAX:

    Measure = DIVIDE(SUM(Table[Value]), 100)

     

    If this answer helped, please click Kudos or Accept as Solution.
    -Kedar
    LinkedIn: https://www.linkedin.com/in/kedar-pande

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support
    8 months ago

    Hi Anonymous,

    Thanks for sharing the update. We glad to hear that your issue has been resolved.

    Your insights and workaround will definitely help other members who might experience similar percentage formatting issues.

    We appreciate your contribution, please continue using the Microsoft Fabric Community Forum whenever you need help or want to share feedback. We're always here to support you.