Hi. I have built a financial dashboard using Mynda's example. All works fine until I added a few lines of data. Now, when I click "Refresh all" data the slicers vanish and all the pivot tables on the lower part of the page lose all year/month rows. I have unchecked the "Hide rows with no data" on the year slicer and it shows ">04/11/2025" before I try the refresh. The date of the last data row before i added the extra rows was 03/11/2025.
I imagine there's a problem in the transactions table but I can't work out what it is.
Has anyone any ideas?
Thanks
John
@zedbeeble
Difficult to say without seeing the file. Would you be able to share it here? Just remove any private and confidential information, but leave everything else as it is so that we can see the problem.
Hi there Riny,
I'm trying to do what you suggest but it's tricky to hide the details. What I think seems to be happening is the the report is stuck as if it has cached the original Transactions table and then when I ask it to update it presumably has problems with some sort of conflict. I'm going to try just rebuilding the report from scratch.
I'll let you know if that works.
Thanks
John
@zedbeeble OK, but just to be sure we are on the same wave-length. Exactly which template are you working off?
