Forum

Hi Eva, Your Slicers are connected to the original source data. If you created a new version of the data for your charts, then you need to start fr...

Hi Jim, Session 6.11 of the Power query course covers error handling. For some pointers on how you might use it in your code, please see this examp...

Hi Joe, Welcome to our forum! How are you determining whether an order has shifted? Are you expecting the same sales each quarter? Mynda

Hi Ngozi, Welcome to our forum! The data isn't in the wrong format. It's just that your PC uses mm/dd/yyyy and mine uses dd/mm/yyyy. This is a c...

Hi Declan, Unfortunately, 'Show report filter pages' is not available with Power Pivot PivotTables. The only workaround would be to write a VBA rou...

Hi Chris, Please see this post which explains that this error should be cosmetic. You should be able to refresh them individually. Hope that helps...

Hi Martin, Welcome to our forum! I recommend you use Power Query to extract the data you want/remove the transactions you don't want. This isn't re...

Hi Andrea, You haven't answered my question. I asked what fields you have in your PivotTable that contain a date. It would help if you shared your ...

Hi Declan, If you're loading the data to both the Power Pivot model and a Table in the Excel worksheet, then you are doubling up on the data stored...

Hi Tan, Try..otherwise is designed to trap errors. It's like IFERROR in terms of equivalent Excel functions. More on error handling in Power Query ...

Hi Tan, You can turn on the 'Totals' in Excel Tables via the table tab in the ribbon. Do this in the table that loads into Excel after you click 'C...

Hi Mohamed, Welcome to our forum! Your question is a bit light on details, so I'll start by pointing you to our posts on Map Charts: Map Charts...

Oh, ok. Glad you figured it out 🙂

Hi Andrea, Remember DAX measures also use row and column context to filter. Do you have any month/date fields in the PivotTable that could be apply...

Hi Christina, Welcome to our forum! Thanks for sharing your file. It's great to see you're using dynamic arrays 🙂 The difficulty you're havin...