Forum Discussion
Solved
Percentages displaying as decimals.
Hi I was wondering if someone can help me I think I'm going mad. I have a Line and clustered column chart where the data on the line refuses to display as a percentage. The original data in exce...
Go to the Modeling tab of the ribbon. Click on the column/measure. Click the little % button in the formatting area.
AH HA!!! I clicked on the column field with the table and then it let me click on the % sign and the data changed!!
Thanks very much Greg you've saved what hair I have left.
Matt.
Can you only set the data format at the TABLE or DATA SOURCE level? What if I want to have the data displayed as a decimal in one chart and a percent in another chart? Is there a way to set the data format at the CHART level in Power BI?