Enquiry an incorrect data column

[Anonymous]

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?

[v-ssriganesh]

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.

[Anonymous]

Many thanks for all the contributions. 

[Kedar_Pande]

@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

[Anonymous · Accepted solution]

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)

[PhilipTreacy]

@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]

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

[pankajnamekar25]

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]

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

[Anonymous]

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

[amitchandak]

@Anonymous , first of it should have been a measure not a column. Also, we can control format at Report, Visual and element level. I doubt the label format is the issue here 

Value of Data Label