Dynamic Pivot Table with Multiple Tables using Power Query
In this article, we have created a dynamic Pivot Table with Multiple Tables using Power Query. We have taken 4 different yearly Sales Table as given in below image- Dynamic Pivot
Tag: Pivot Table
Custom Toggle Button in Excel and Power BI
In this article, we have created a custom Toggle Button in Excel and Power BI to toggle the Chart and Table on click of this toggle button. This trick could be
Pivot Table Super Tips in Excel
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
KPI in Power Pivot for dashboard and report
Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI in Power Pivot for dashboard is designed to help users quickly evaluate the
Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)
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
Create Relationship in Power Pivot
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
RAG waffle Chart visualization with Slicer
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
10 Useful Pivot Table Tips
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
Custom Style of a slicer in Excel
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
Change% in Pivot Table
In this article you will learn how to show Change% in a pivot table. For example, you have month wise sales and revenue in your pivot and you have to