Forum Discussion

jakeryan56's avatar
jakeryan56
Advocate II
8 years ago

Problem filtering by month name

Hi. I am having a very strange problem.  I have a sales tracker where there are multiple tables (sales data, timesheet data, etc). All of these tables have a Month_Name column that is linked back to ...
Need Help
jakeryan56's avatar
jakeryan56
Advocate II
8 years ago

No I already checked that - no report or page level filters are applied. 

It seems to be a glitch with 01/04/18 accross the entire platform. Even when I try and filter using the exact same month name field (not the other month table) it doesn't show any results when a filter is applied - see the two screenshots. This is extremely frustrating 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

And just to double check, the field you are using for the slicer is exactly the same as the field used in the 3rd column of your screenshot?  It's not a field with the same name in a related table?

  • jakeryan56's avatar
    jakeryan56
    Advocate II
    8 years ago

    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.

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      8 years ago

      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

      • bamaram's avatar
        bamaram
        Regular Visitor
        8 years ago

        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)