Forum

Okay! Let's give it another try and let's combine the first part of your query with the last part of mine. As you can see, English PQ calls the functi...

When you create a structured table, Excel put the filter buttons in the header rows. You can use these to filter but also to sort columns.

Thanks, and apologies for not being clear. You mentioned that you had attempted to combine files yourself and you get the contents of all files one be...

Made some slight modifications to your file. See if it works for you. I don't believe you need the ranking columns and formulas. Use structured tables...

Can you share the file you are working on?

Indeed, when you combine files from a folder as you describe, PQ creates one table, listing the content of all files one after the other. Let's assume...

I tested you formula and it does produce different results depending on what's in either of the three columns referenced, as demonstrated in the attac...

Can you share your file? It's difficult to envisage what you're doing exactly.

Not sure I follow your additional requirements, though I feel you need to look into changing the way you set-up the data. I would unpivot columns J...

Well, you can't connect a slicer to both a table AND a pivot table/chart, though you can connect a single slicer to multiple pivot tables provided the...

Opened the file, see the bar chart but no slicers. ???

The column headers aren't the same. That's why PQ places them in separate columns. Some columns explicitly refer to Technical Service department, othe...

Okay, now I'm with you. No need for DM or Power Pivot. See if you can follow / reproduce what I did in the attached file. You may want to fine-tune it...

The query merely combines all tables from the current workbook. The first time you run it, PQ only 'sees' two tables, but when you load the result bac...

Okay! But please upload the screenshots again as they didn't come through.