Forum

Hi Cheryl, There's no built in way to do this, but this thread explains a hack. Mynda

Allow it to Close & Load, then in the Queries pane on the right of the Excel Workbook, right-click the query > Load to. Here you can change the...

Hi Mohammed, Welcome to our forum! Drill up/down doesn't filter, it just shows you more or less detail. If you mean cross filtering by clicking ...

Hi Jan, I think it would be better to bring the rebate into the costs table in Power Query where you can do a merge where the year and clinic ID ar...

Hi Jordan, I suspect there might be a space lingering in one of them. Have you used Trim/clean in the Extract drop down? Mynda

Hi and welcome to our forum! First of all, you should put all the data back into one tab as this is the way Excel was intended to be used and will ...

Hi, Thanks for sharing the files. The 3 CSV files have different column headers. This is the problem. P1 column headers end in _A, P2 end in _B and...

Sorry, no PDF, but you're welcome to copy and past it into a Word document and make your own PDF of notes.

Hi, the images don't help a lot because in one of them I don't know what step they're showing. What is the source of the data? It appears to be anothe...

Hi and welcome to our forum! It looks like the very first thing you do (second line of code) is filter the source to only return the file called sf...

Hi Martin, Indeed, not smart 🙂 Go to session 2.05 for getting files from a folder and watch the video below the first video (on the same page)...

Hi William, Welcome to our forum! On the page for Session 1.03 there is an image that colour codes the menus in earlier versions of Excel to the...

Hi Bob, Have you tried the solutions for slow refresh times offered here? Re-using the query elsewhere will still result in a slow refresh unless y...

Hi Ian, The tool tips that appear when you mouse over the segments come from your source data. If you expand the Horizontal Category Axis labels to...

Hi Robert, I'm wondering why you aren't using PivotTables and Slicers for this task? No VBA or macros required, no maintenance. Just have your user...