Forum

Hi Matthias, That error is caused when you load a table from Power Query to the Power Pivot Data model and subsequently make changes to that table ...

Hi Jørgen, If he is already able to create it with Power Pivot in Excel then it's likely you can do it in Power BI, as it also uses the Power Pivot...

Hi Peter, It sounds like a bug. Are you able to create a sample Excel file that we can see and try to replicate the issue? If it is a bug I can rep...

Hi Rita, Add the Week field to the Filters area of the PivotTable and filter the weeks you want the running average for. Mynda

Hi Jørgen, I've not considered a waterfall chart for this purpose before. Have you tried it? Did you have any problems creating it? Other chart ...

Still no takers, Maurizio. But at least you are making progress.

Looks like your challenge is probably too time consuming, Maurizio.

Hi Rita, This is best done in a PivotTable or Power Pivot PivotTable. Please see example attached. Simply add the Hours field to the Values area...

Hi Christopher, Thanks for sharing your file. I can see it's a bit more complicated than I envisaged. In the attached file you'll see you have t...

Hi Anne, Select both columns > right-click > merge columns. Mynda

Hi Matthias, Can you please upload a sample Excel file so I can better understand what you're working with and trying to achieve. Mynda

Hi Matthias, From memory there are some bugs with filters. However, if your query updates then the filter would need to be reapplied to the Excel T...

There's no add-in for Excel 2016. If you're an Office 365 subscriber then you get automatic updates, but there are different channels and the channel ...

Hi Christopher, Welcome to our forum. Looks like your file didn't upload. You need to click the 'Start Upload' button after choosing your file. ...

Hi Cele, Sounds like you need to upgrade your install of Excel. Those are new features released after the initial release of Excel 2016. Mynda