Forum Discussion
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...
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)
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:
IN the matrix table, power bi display the value correctly. However, the chart becomes decimal.
in the calculated column, here is the format "#.#"%"
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
