Hello I am back again.
After we have solved my previous issue I now have the following problem.
In my raw data file I have dates from 2018 and 2019 now in the pivot table I only see 2019 data.
There are no filter in the power BI, setting to date is correct
What do I over look. I have attached the file
REgards
Dick
Hello,
Sorry, there is no file attached.
Hello
I have had this problem before that uploading fails.
I try again maybe the file is too big.
Even when I zip the file 320KB is too much we need to find another way.
Regards
Dick
Hi Dick,
Just now saw your post of some weeks ago. I managed to download your zipped file and unpacked it.
I'm not sure if I understand you well. I don't see a pivot table on the dashboard sheet?
But the timeline you maybe mentioned (Begindatum taak) contains both 2018 and 2019. If you make it wider, you can see that.
On the other hand: the graphic 'onderhanden' revers to the sheet 'Basis data'. And on that sheet you only have 2019 dates (except F152, but that can be a mistake).
So it above not is what you are looking for, maybe it's possible to explain more in detail where you mis something and what it is you mis?
Frans
Hello Frans,
Thank you for the reply.
The pivot table is the master sheet from which I collect all data.
F152 was a typing mistake and corrected now.
In the master data sheet I am missing the 2018 data. I have put manual is the basic data sheet.
Dick
Hi Dick,
If you go to the PivotTable on the Masterdata sheet and change the timeline to show 'Years' you'll see that it is filtered to 2019 only. When you change this to show 2018 you'll see there are two Client Numbers with 2018 data; 130441 and 130544.
Mynda
