Forum

File is attached. Not sure why it didn't stick the first time.

Hi Sylvain, Thanks for sharing your solution. I had a quick look at your file but there are a lot of steps so I didn't spend time trying to follow ...

Hi Tobias, You need to unpivot the data so that you don't have your monthly data spread across multiple columns. You can do this with Power Query. ...

Hi Cedric, Power Query session 7.02 deals with this scenario. Mynda

Hi Bob, Sounds like either your internet connection is slow or the web page is not being responsive enough at the time of Close & Load. Can ...

Hi Timothy, I'm in the process of updating the course for Excel 2016 onward and have decided to release it as I complete it rather than make you wa...

Hi Nick, Have you tried using Files From > Folder? Then you can choose the two tables you want to import. Mynda

Hi Aye, Please try to create the DAX formula yourself. If/when you get stuck then you can share your attempt with us. Our job isn't to do your work...

Hi Alan, Thanks for explaining the objective of the chart. I've given it some thought and I think your best option is the stacked column chart and ...

Hi Tracy, Nothing you can do to add data to it. You'll have to delete it and add the table to the data model again. You'll also have to re-create a...

Hi Mark, No, you can't install it as such. Have you checked your 'Insert' tab to see if you have a button called Insights? That's what it used to b...

Hi Alan, It can't be done automatically. You'd have to select each segment of the chart and manually set the colour. I can't suggest an alternat...

Hi Mark, It's odd, but also your screenshot does not display the same records which implies there might be errors in the Power Query data??? Myn...

Hi Shantanu, You need to force months to be sorted based on a numeric column, rather than text. You do this by setting the 'Sort By'. This is cover...

Hi Tracy, You can't with a Pivot Chart. Basically what you see in the PivotTable gets plotted in the Pivot Chart and you need the base year for the...