Forum

Hi PB, I'm not following you. Please provide a sample Excel file that shows the PivotTable starting point and the desired end result. Mynda

Hi Harrie, Thanks for the screenshot. My guess is it's either the top left green button or bottom left grey button. Presumably you've tried these? ...

Hi PB, See image attached with the steps I'm taking. Again, I can't reproduce the issue you describe. I also put the Category filter in the Filters...

Hi Oana, Thanks for sharing your file. This isn't possible because references made from objects cannot be relative. You would have to create a sepa...

Hi Pieter, Please try uploading your file again. Be sure to click the 'Start Upload' button after selecting your file and wait for the grey check m...

Are you able to share your file? It's difficult to troubleshoot without seeing the file.

I can't reproduce the issue. When I copy and paste as values from a PivotTable I only get what I see in the cells, i.e. no underlying data or connecti...

Hi Oana, Can you please share your file so I can see what you've set up so far with the name manager, or at least a small sample file with your exa...

Hi Chris, Power Query cannot load files to a folder. It can only load data to Power Pivot/Data Model, table in a worksheet, PivotTable, Pivot Chart...

You should be able to copy the PivotTable and paste as values. That way the underlying PivotTable is not copied, only the data visible in the cells. Y...

Hi Tim, Welcome to our forum! Try removing the 'Changed Type' step to see if that fixes the issue. Mynda

Hi PB, I'm not sure I follow your question. Why do you want to copy and paste? Why can't you use the Filter to select A, C and D companies? Perh...

Hi Cecile, Welcome to our forum! This will be a limitation of the API. Often companies limit API calls to reduce load on their servers. You would n...

Hi MJ, Yes, just add them together in the measure e.g.: =CALCULATE(...) - CALCULATE(...) - CALCULATE(..) Mynda

It's either that or insert two slicers, one for each Project Manager level. When a selection is made in the first Slicer it will filter the second to ...