Pivot Table Archives - Page 2 of 2

Dynamic Pivot Table with Multiple Tables

Combine Tables into a Dynamic PivotTable with Power Query

January 31, 2021October 10, 2026 PKComments Off

Power Query consolidates the tables used in this Excel PivotTable example: four yearly Sales Tables and an Employee Master containing supervisor and employee names. The final report includes slicers and

Power BI VBA

Custom Toggle Button in Excel and Power BI

August 9, 2020October 10, 2026 PKComments Off

A custom toggle button in Excel and Power BI lets readers switch between a chart and a table in the same dashboard area. This tutorial demonstrates two implementations: Excel VBA

Excel Tips and Tricks

Pivot Table Super Tips in Excel

February 16, 2020October 7, 2024 PKComments Off

In this article, we have used two excel super tips for pivot table. You can use this tips in your excel report wherein you use pivot table. Below are the

Power Pivot

Power Pivot KPIs in Excel: Create, Edit and Delete

January 15, 2020September 19, 2026 PKComments Off

A Power Pivot KPI compares a base measure with a target and displays a status using defined thresholds. This Excel tutorial shows how to create, display, edit and delete a

Power Pivot

Calculated Column in Power Pivot: LOOKUPVALUE vs RELATED

January 9, 2020October 9, 2026 PKComments Off

A calculated column in Power Pivot adds a new field to a data model table, computed row by row with a DAX formula. In this tutorial you have an Orders

Power Pivot

Create Relationship in Power Pivot: Build a 3-Table Data Model

January 3, 2020October 9, 2026 PKComments Off

To create a relationship in Power Pivot, you add each table to the Excel Data Model and then link a column in one table to the matching column in another,

Charts and Visualization

RAG waffle Chart visualization with Slicer

November 18, 2019March 5, 2025 PKComments Off

In this article, we have create a RAG waffle Chart visualization with slicer to display the Red, Amber and Green percentage. We have used Conditional Formatting and linked picture feature

Excel Tips and Tricks

10 Useful Pivot Table Tips in Excel (Free Practice File)

October 25, 2019October 9, 2026 PKComments Off

These 10 pivot table tips fix the small annoyances that slow down every Excel report: column widths that jump on refresh, running totals and ranks you still build with helper

Excel Tips and Tricks

Custom Slicer Style in Excel: Create, Reuse and Set as Default

July 8, 2018October 9, 2026 PK0

A custom slicer style in Excel lets your slicers match the colours of your dashboard instead of the default blue, orange and grey buttons. In this tutorial you will create