Forum

Hi David, It doesn't like the Parent list being in a Table. If you convert this to regular cells and rename it 'Parent' as you'll lose the name whe...

Hi Lea, Have you tried changing the language settings in Excel via the File tab > Options > Language? Mynda

Hi Conny, Welcome to our forum! It's great to hear you found my tutorial helpful. What you have in your Power Pivot model are 3 fact tables. If ...

Hi Jesus, Thanks for sharing your file. I can see it is not in the correct tabular layout. You need to use Power Query to unpivot the 'h' columns i...

Hi Oscar, Welcome to our forum! Please share your file so we can see what might be causing the problem. Mynda

Hi Jesus, The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the fi...

Hi Oli, No file attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the file size before...

Hi Kevin, Please provide a sample Excel file. It looks like you didn't choose the correct column for the values. Mynda

Hi Esteban, Welcome to our forum! Thanks for sharing your file. Duplicate the query, then filter the third column to keep just the rows that con...

Hi Olesea, Welcome to our forum! The error message occurs because it is expecting to find a column called 'Transaction date' in the source files...

Hi Nick, Welcome to our forum! The short answer is, you can't sort by the Show Values As percent columns in regular PivotTables, only the absolu...

Hi Cullen, Go to the Data tab > Queries and Connections. In the Queries and Connections pane that opens you'll see two 'connection only' queries...

Hi Kevin, Welcome to our forum! You need to pivot the description column. If you attach a sample file it's easier for us to help you. If you get...

Hi Twigs, Welcome to our forum! Your data is in the wrong layout for the chart to work the way you want. In the attached file I've unpivoted yo...

Hi Cullen, Welcome to our forum! Obviously this requires a different approach which has quite a few steps, but most importantly, the warnings need ...