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
1 answers ( 1 marked as helpful)
Dimitar Shutev
Instructor
Posted on:
08 Nov 2022
0
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.