Last seen: Jul 1, 2026
Hi Troy, If the website data is in a HTML table, as opposed to JavaScript, I would connect from Power Query to the web and get the data and clean i...
Hi Troy, That's an odd error. I couldn't find a lot of info on the net where others had had the same error either. Since Power Query is working ...
Ah, sorry I missed point 4. You either have to add a Slicer for the year as well, or you can create a yyyy-mm Slicer using this technique: Let me...
Hi Gabriela, Glad it's working now, although you shouldn't have to close the file completely for the field to appear. Maybe your PC just needs a re...
Hi Moavu, Please attach a file with your attempt so I can see where things might be going wrong. Mynda
Hi Tobias, I'm afraid you have hit the limitation of the Pivot Chart. Pivot Charts only display what's in the PivotTable and as a result the abilit...
Sure is, Bob. It's called a ghost series (well that's what I call it anyway) and I cover it in session 4.19 of the Dashboard course. Let me know if...
Hi Gabriela, That sounds odd. Can you please send me your file so I can do some testing on my Excel 2010. Thanks, Mynda
Hi Moavu, I refreshed the query in your file attached and also got yesterday's date. That is by design because today isn't over yet. To change t...
Glad you liked the chart. Yes, the total column only makes sense for the labour expenses. You can have it in this table, but it means the auto-popu...
Hi John, Sounds like the perfect job for a PivotTable. Let me know if you get stuck putting it together. Mynda
Hi Jennifer, I already replied to your email on this same topic but I'll reply here for the benefit of others too. Excel 2013 and Excel 2016 are...
Great idea, Col. I prefer to separate the data into their own charts to make it quicker to read, but that doesn't always help with comparisons. ...
Hi Troy, I think you've got a pretty good idea of what Power Pivot does. Another way to look at it is to think of it as a blend between Access; bec...
Hi Troy, I love your frog anaolgy 🙂 In the attached file you'll see on sheet 'Tabular' that I've consolidated your data into one table. You'll...