Forum Discussion
Excel 2016- Pivot table and Power query
Dear All I have an excel 2016 spreadsheet where i have information, someone previously set up a power query and pivot table, however i am unable to refresh the data I have changed the file path b...
Hi Kaz28EN, thank you for reaching out to the Microsoft Fabric Community Forum.
Please follow below steps:
- Go to Data -> Click Get Data -> From Other Sources -> From Workbook (if pulling from another Excel file). If the data is within the same workbook, select From Table/Range for each sheet.
- In Power Query, go to Home -> Append Queries -> Append as New. Select both tables, click ok.
- Ensure that Date is in Date format, Result Interpretation is numeric, Click ‘Close & Load -> Load’ as a Table in Excel.
- Go to Insert -> Pivot Table -> Select the new consolidated table. Set up the fields.
- Select the Result Interpretation column in the Pivot Table. Go to Home -> Conditional Formatting -> New Rule. Use a formula (According to the need).
- Click Data -> Refresh All whenever new data is added.
Please check the attached document for your reference.
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Hi @Kaz28EN, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.