Forum

Hi Nesha, Welcome to our forum! To be clear, if the source data contains all sectors and you use Power Query in Excel to filter the data for ea...

Hi Diaa, When I try to add a calculated item in your file I get the error "This PivotTable report field is grouped. You cannot add a calculated ite...

Hi Stan, If a query is returning duplicate data it's because it is referencing itself somewhere along the way. Either the original query is getting...

Hi Mark, Having a look at your version I can see it's up to date. I'm not aware of any Power Query performance issues associated with a move from W...

Hi Franics, I couldn't see any attempt at writing measures in your file. It's always best if you can show us what you've tried. That way you'll lea...

Hi Dianne, You stopped one step too soon. You simply need to add another filter for the Period field: = Table.SelectRows(#"Filtered Rows1", each...

Hi Nick, Thanks for sharing your file. When you first asked the question I didn't realise you wanted to filter multiple fields based on multiple pa...

Hi Terry, Thanks for clarifying. You can only add a series to a Pivot Chart where that series is in the PivotTable that's feeding the Pivot Chart. ...

Hi Maarten, Change the layout so that the rows contain Employee and then competency. Then select one of the competency row labels in the PivotTable...

Hi Bruno, When selecting items in a single Slicer the criteria is considered OR. There's no setting available to change this, sorry. Mynda

Hi Francis, It's difficult to say without a sample file that shows whether your data for budget and committed are going to be in separate tables (a...

Hi Tmac, Welcome to our forum! Your question "how would I go about projecting the tons (baler) & savings by not being placed in the compacto...

Hi Francis, I've moved this question to the Power Pivot forum because you shouldn't be calculating the running total in Power Query if you want to ...

No worries. It's a good idea to completely finish the courses before you try to build your own reports 😉

Hi Aileen, You haven't done this part: "You then multiply the formulas feeding your chart by the values in the Visible column. If it's true i.e. vi...