Last seen: Jul 24, 2026
Hi Andy, This is a common problem with Pivot Charts. You would need to set the items in the Slicers to 'show items with no values' so they are alwa...
Hi Stephanie, Please see this tutorial on the different ways you can locate and view your content. You may also find Apps and the datasets hub usef...
Hi John, I'm not sure what the cause of this is. I can still see the filled map visual however, I had another student report the same thing last we...
Thanks, Robert! And you to 🙂
Glad you got the PivotTable doing what you want....and managed to share the file 🙂
Hi Robert, I would put all 29 million rows in a single CSV file. Use Power Query to get the CSV file and do the lookup in Power Query using Merge T...
Hi Garth, HNY to you too! The file hasn't uploaded. Maybe it's too big for the forum limit? When it uploads correctly you will see it attached i...
Hi Garth, Welcome to our forum! Please try uploading your file again. You need to click the 'Start Upload' button after selecting your file, then w...
Hi Maria, For your desired result you'd need to perform a COUNTIFS for the count of delay and only return the name using FILTER. Alternatively, you...
Hi Chris, Square brackets declare column names. You cannot change them to double quotes in the 2nd and 3rd arguments of the formula. The last argu...
Hi Thomas, Welcome to our forum! It's great to hear you found my videos helpful. You can use Power Query to automate the updating of your report...
Hi Chris, The null in your source data is not a true null value and it's part of the problem. First you need to remove the null from cell A11 in yo...
Hi Bruno, There's no way to refresh the data and not have it overwrite the previous query results. If you want to keep a copy of the data, then you...
Hi Paul, First, you need to put your data in a tabular layout. The data on the GP & Occupancy sheets is not in the correct format because it ha...
Hi Helen, Great question. There's no way to allow hover visibility in a protected worksheet/workbook. Best option is to give your colleagues access...