Forum Discussion
pwrch
4 years agoFrequent Visitor
Chart not showing total amounts correctly
I have a table with the following columns
Name | Group | MonthsRemaining
I have a chart to display the total number of students we'll have every month for the next 12 months and the problem that I run into is that chart won't display anything when there are months with no graduations.
My current measure looks like this:
CALCULATE(
COUNTROWS(Name),
ALLEXCEPT(Student, Student[Group])
) -
CALCULATE(
COUNTROWS(Name),
FILTER(ALLEXCEPT(Student, Student[Group]), Student[MonthsRemaining] <= MAX(Student[MonthsRemaining]))
)
Any help will be greatly appreciated.
Thank you!
pwrch , You should use a date table and have a month year in Date table, Join it with the date of your table .
And then use this option with month year in visual
2 Replies
- amitchandak
Super User
pwrch , You should use a date table and have a month year in Date table, Join it with the date of your table .
And then use this option with month year in visual
- pwrchFrequent Visitor
Thank you this worked perfectly!