Daily Sales Dashboard in Excel
In this article, we have created a Daily Sales Dashboard to analyze the Daily Sales trends. We have displayed 4 metrics in this dashboard- # Of Calls: The number of
Tag: Pivot Chart
Cross Filter Functionality in Excel Chart
Excel is a powerful tool that provides a wide range of features to help you analyze and present data effectively. One of the most key features in Excel is the
3 Useful Tips for the Pivot Chart
In this article, you will learn 3 useful tips for Pivot Chart. Using these tips you can create an interactive Excel Dashboard. Learn and download interactive Excel Dashboard free of
Dynamic Comparison Analysis Chart in Excel
In this article, you will learn how to create a dynamic comparison Analysis Chart in Microsoft Excel. Using this chart you can compare one employee's performance with other. We have
Ideas in Excel
In this article, we have explained how to use Ideas in Microsoft Excel. Ideas are used to get the suggestion and insights from your data. You can ask any question
Dynamic Filled map in Excel
In the article, You will learn how to create a dynamic filled map in Microsoft Excel. Filled Map is available with Office 365 subscription. You can display the Region, country,
Custom Toggle Button in Excel and Power BI
In this article, we have created a custom toggle button in Microsoft Excel and Microsoft Power BI to toggle the Chart and Table on click of this toggle button. This
SUMX Function in Power Pivot
In this article, we have explained how to use Measure in Pivot Pivot data model. We have taken the example of SUMX function to calculate the revenue. On the base
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
Drill Down/Drill Up Feature in Pivot Chart
In this article, we have created a drill down/drill up functionality in a Pivot chart. We have created a hierarchy in Power Pivot data model to create this. Below are