Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Do you have any other filters turned on that could be affecting the results? Say a page, or report level filter?
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
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?
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 ( 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)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |