Pivot Table Archives - Page 2 of 2

Dynamic Pivot Table with Multiple Tables

Combine Tables into a Dynamic PivotTable with Power Query

January 31, 2021September 19, 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, 2020September 19, 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 6, 2024 PKComments Off

In this article, we have explained how to use calculated column in Power Pivot Data Model. We have taken the example of Orders data wherein we have product level Unit

Power Pivot

Create Relationship in Power Pivot

January 3, 2020October 5, 2024 PKComments Off

In this article, we have explained, how to create relationship in Power Pivot data model. We have taken 2 dimension table and once fact table. What is Power Pivot? Power

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

October 25, 2019October 7, 2024 PKComments Off

Pivot Table is useful and power full feature available in Excel. Learn the below given 10 useful Pivot table tips in Excel- 10 Useful Pivot [caption id="" align="aligncenter" width="813"] 10

Excel Tips and Tricks

Custom Style of a slicer in Excel

July 8, 2018September 7, 2024 PK0

In this article you will learn how to create a Custom Style of a slicer in Excel. By using the custom style in Slicer you can make your slicer based