Forum Discussion
Problem filtering by month name
That is correct - it is the exact same field as the one in the third column and not the related column. I get the same results whether I filter on the related column or the same field which is what makes this so weird.
Any chance you can share your PBIX file with me? Upload it somewhere like dropbox or onedrive and PM me a link.
remove all other tables from the model first if you like
There can be 2 issues :-
#1.
You have to check the actual dates -
eg:
other months would have been of same date and april would have been different
Feb 2018 -02/01/2018
Mar 2018 - 03/01/2018
Apr 2018 - 04/12/2018
#2.
Issue in Month table , April should be missing( If its a manual table check whether you have added April , if not add Apr and try it would work)
There can be 2 issues :-
#1.
You have to check the actual dates -
eg:
other months would have been of same date and april would have been different
Feb 2018 -02/01/2018
Mar 2018 - 03/01/2018
Apr 2018 - 04/12/2018
#2.
Issue in Month table ( If its a manual table check whether it has Apr date , if not add Apr and try it would work)
