Super User
Super User

Questions tagged [powerpivot]

PowerPivot is a data mashup and data exploration tool based on xVelocity in-memory technologies providing analytical performance to process billions of rows at the speed of thought.

PowerPivot is a free add-in to the 2010 version of the spreadsheet application Microsoft Excel and is a built-in functionality of Excel 2013. It extends the capabilities of the PivotTable data summarisation and cross-tabulation feature by introducing the ability to import data from multiple sources.

For key features see Wikipedia.

114 questions
12
votes
4 answers

Excel 2010 PowerPivot: How do I show items with no data?

In standard Excel pivot tables, there is an option for fields that allow you to force display of all items even if there are no results for your current selection. Here's the option: However, using the PowerPivot add-in for Excel 2010 this option…
Andi Mohr
  • 4,315
4
votes
1 answer

Auto formatting new pivot rows to data bars

I have a pivot table that takes data from database and displays it as a data bars. Problem is, that the data is updated daily - every day new row is added so the pivot table is growing. Unfortunately each new row doesn't follow the formatting of…
Yasskier
  • 171
3
votes
1 answer

calculated column in pivot table from power pivot

From SQL server I have a query that gives me daily transaction numbers for few companies per day, something like DATE Company Total Tax year 2013-04-24 ABC 50 2013 2013-10-15 DEF 20 2014 And so on.…
Yasskier
  • 171
3
votes
1 answer

Changing font size in Power Query

I have started to fiddle with Power Query a bit and thing that is pretty annoying is size of the font in formula bar and advance editor. Its way to small. Also when you manually enter formulas in custom column its tiny as well. Is there any way that…
IGRACH
  • 478
3
votes
2 answers

Excel PowerPivot Relationships

I have an issue when using PowerPivot in Excel 2016. After creating a relationship between two tables, and afterwards create a pivot table from the data model, the resulting pivot ignores the relationship. Below you can see my two tables - Table 2…
Nichlas H.
  • 556
2
votes
1 answer

How can I publish excel workbook with data populated using PowerQuery to SharePoint or website and have the data refresh on the site?

I have an Excel Workbook that gets data from an API using PowerQuery, to populate the tables. There are also filters and slicers in the workbook. Is it possible to publish this workbook to SharePoint or another web site and have that data…
bcarn
  • 21
2
votes
1 answer

With PowerPivots, find items that appear *only* in one category

With PowerPivot, how do I find items only in one category? Here's an example: item category number obera f6 7 artois f7 2 obera f7 3 ella f6 9 If I choose f6, the output for this example would…
PonyEars
  • 957
2
votes
1 answer

How should I share workbooks that use PowerPivot?

I've used powerpivot to make a super-awesome report. But now I need to share it with my co-workers, who do not use powerpivot. When I send someone a powerpivot report to users without powerpivot installed, none of the controls work--you can't…
dan
  • 433
2
votes
0 answers

Ragged hierarchies in Power Pivot

In Power BI, one can use the Hierarchy Slicer vis from AppSource to hide items that contain blank values: Is there a feature similar to that, but in Power Pivot? I want to hide the blank values, but I'm not to filter them, since filtering will…
emil
  • 21
2
votes
2 answers

Cannot group field in Excel PivotTable

I know this question has been asked before, and the usual answer is "your dates are not all stored as dates!" I highly doubt this is the case here. I'm using PowerPivot which pulls data from a database/table. I use a SQL query in PowerPivot to pull…
Sultan of Swing
  • 121
2
votes
2 answers

Changing the Workbook Connection String in PowerPivot

I recently had to move a PowerPivot report from one terminal server to another. I was able to get the PowerPivot Data Connections up and running without much trouble. When I click Test Connection, it is successful. Part of this involved changing the…
whysgai
  • 21
1
vote
0 answers

How to create a 100% stacked column chart if I have total

I'm trying to create a 100% stacked column chart using Excel 2013 Pivot Table to show what % of Column A is of a Total Column B. However the 100% stack column chart doesn't seem to work if I have a Total Column, only columns that sum to a total. If…
user1207381
  • 141
1
vote
0 answers

Excel 2013 Workbook Size Optimizer not working

I have a large PowerPivot/PowerView workbook that needs to be cleaned up. Microsoft offers a free tool called the Workbook Size Optimizer for situations like this, but I have not been successful in getting it to work. Either I will click the button…
Ddono25
  • 91
1
vote
1 answer

Powerpivot install fails

My machine runs windows 7 professional (64bit) and I use MS office 2010 professional 32 bit. I'm attempting to (re)install the powerpivot plugin but i get an error stating "installation of powerpivot for excel failed because a higher version…
user456045
  • 11
1
vote
1 answer

Powerpivot: how do I avoid measures from computing until I'm done entering multiple measures?

With Powerpivot, I have many measures (>25) to enter in a dataset that has millions of entries. When entering the DAX expressions for the measures, each time I enter one, Powerpivot takes a long time to calculate that value before it allows me to…
PonyEars
  • 957
1
2 3 4 5 6 7 8