I have a different approach for creating the bar graph as per the attached pic The graph works fine when switching to number, however, it does not work when switching to parentage button

The issue is that every time you use the FORMAT option, DAX is treating the result as text therefore bar charts cannot display text as numbers. You cannot use any formatting with switching between numbers and percentages.

Follow this topic