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