Hi everyone,
I want to remove the first bar (Blank) from the bar chart and the data label will recalculate the % by excluding the blank data. The reason why there are some blank data is because there are some data missing for some students. The DAX formula that I used to categorized the students into different % group is:
RankCategory =
VAR CatVar=[Success_Rate]
RETURN CALCULATE (VALUES ( BenchMark[Category]), CatVar>BenchMark[Lower_Level],CatVar<=BenchMark[Upper_Level])
May I know how should I modify in my Bar chart or modify the DAX formula so that it can achieve my goal? Any help or advise will be greatly appreciated!
