every time i refresh pivot , the column formatted as percentages goes back to decimal? how to fix?

[daveyc18]

title says it all

 

[ExcelToDAX]

Did you right-click within the Pivot table and click Number Format? Formatting just the cells won't work because once the pivot table refreshes, it will go back to the OG formatting.