Log In
Register
Home
New Member
November 24, 2024
Offline
Hi all!
I'm working through the video here. After about 20ish hours of configuration I'm running into something really strange.
The thing is, AFAIK, this work is pretty light as far as Formulas are concerned...Did I potentially screw something up during the Power Query portion of setup that's causing some sort of circular behavior? How can I isolate the root cause? I can't save until I figure it out, but also this isn't the first time I've struggled with this particular portion of the course.
I'm also noticing this particular portion of my data sources seems to be infinitely loading. Partial culprit?
Anywho, that's my first post, hi all! Thank you for having me!
See Answer
Moderators
January 31, 2022
Offline
On the first point, I'm pretty sure that the dashboard in the video contains a formula that comes even close to the 8K character limit for formulas. So, something must have gone wrong. I suggest you do what the message says and save the workbook as an xlsb format to begin with.
Would you then be willing to upload it here so that we can have a look at it.
Regarding the infinite loading comment in the query preview window, I believe that's a know though harmless bug. It's a false alarm and you may ignore it.
Answers Post
New Member
November 24, 2024
Offline
Thanks so much, Riny!
Unfortunately I've got all of my financial data seeded into my version of the sheet so I can't upload it without some manual labor, something to think about for a solution-oriented version of myself for sure.
I didn't manage to identify the root cause, but I did manage to work around it by re-creating everything I'd done on a fresh template of hers, and then refactored it to my liking, this time with bigger and better knowledge to assist since I've built it once before, fun project!
Great to know about the harmless bug, I was so sure it was related.
If you can point out which formula that'd be i'm all ears, I believe there's no formulas in the dashboard itself, but there are two formulas that exist that perform some level of calculation for us.
=GETPIVOTDATA("Actual ",' Report'!$K$16,"Category Type","Income Surplus/(Deficit)")
=GETPIVOTDATA("Variance ",' Report'!$K$16,"Category Type","Income Surplus/(Deficit)")
These live subtly on the Analysis sheet in the template that Mynda provides, but I'm honestly not seeing much else besides these. Honestly I probably wiffed something and double-pasted or something when I was trying to build it from scratch lol.
Regardless! Thanks again for your reply. Your time is truly appreciated. If you'd like to see what my own version of her project became, it's here. I'm extremely proud of it!
1 Guest(s)
