Forum

Hi Christine, Yes, Power Query can fix these dates. It looks like this might have been a text or CSV file that you've opened in Excel? I say this b...

Glad you got it working, Rob.

Hi Miguel, Each series is effectively 2 series, one for the line and one for the labels. If you open the Select Data Source dialog box (right-click...

Hi Miguel, Change the chart type to 'Line chart with markers'. Not scatter and not stacked line chart. Then add/edit all of the series to point ...

Hi Miguel, Thanks for sharing the file. You need two or more points to draw a line. If you look at series 1, you can see it references cells AC1...

Hi Miguel, Welcome to our forum. The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey c...

Hi Robb, Thanks for the file. Your data is in the wrong layout. You need to unpivot the values in the Table_Measure table. You shouldn't have s...

Hard to say without seeing how your data is structured and the PivotTable layout. Have you tried using just =DIVIDE(Table_Measure[isfrn], Table_Measur...

Hi Lisa, You just need to add a column to the source data and chart for the balance of 950 and change the chart type to Stacked Column. See file at...

Hi Lisa, The images uploaded, but the Excel file didn't. Please try again and wait for the grey check mark to appear beside the file size after pre...

Hi Rob, That's a lot to try and visualise and as a result, I'm not sure I completely understand the scenario. For one, I don't know where the sourc...

Hi Charles, This post covers the different merge types in Power Query and should answer your question. If you're still stuck, come back with an exa...

Hi Peter, Here is the original post and answer. Note: even with Office 2021, you still don't have this functionality. It's only available with ...

Hard to say without seeing the file, but have you tried fully qualifying the column name with the table name e.g.: =MEDIAN(Table[column]) If tha...

Hi Farah, You can use Power Query assuming your example is consistent in that each section's name is split by an underscore. If so, please see exam...