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)
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
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