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
Tag: Power Pivot
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 Feature functionality in a Pivot chart. We have created a hierarchy in Power Pivot data model to create this. Below are
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