Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jakeryan56
Helper III
Helper III

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 a Month List table. In the reports, I can then filter by Month_Name (e.g. "March 2018"). This has been working completely fine for months until all of a sudden April 2018 where nothing shows when selecting this value even though the values are definitly in the other tables. Any ideas?

 

I set-up a test to see what invoices show for each month selection. March works fine and shows results where in the second screenshot you can see April is blank despite seeing in the third screenshot that there is definitly data for April

 

Capture.PNGCapture2.PNGCapture4.PNG

7 REPLIES 7
Phil_Seamark
Employee
Employee

Do you have any other filters turned on that could be affecting the results?  Say a page, or report level filter?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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 

1.PNG2.PNG

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?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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)

 

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)

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.