Just solved it, it looks to be an Excel bug, if there are hidden rows and or empty rows on main table/columns, Excel will not show percentages on pivot chart, found out issue when copied original table/columns to another sheet.
Just an FYI if it happens for someone else.
Bookmarks