**7**

votes

**6**answers

28k views

### Excel 2010 PowerPivot: How to 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 ...

**3**

votes

**1**answer

456 views

### 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 ...

**2**

votes

**1**answer

41 views

### 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 ...

**2**

votes

**0**answers

93 views

### 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 ...

**2**

votes

**1**answer

2k views

### 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 ...

**1**

vote

**1**answer

151 views

### Excel 2010 PowerPivot: How do I avoid apostrophes being displayed as â€™?

When I import a text file to PowerPivot containing apostrophes, they are automatically converted to â€™.
I've been manually correcting the few that I find in the PowerPivot window, however when I do ...

**1**

vote

**1**answer

20 views

### 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 ...

**1**

vote

**1**answer

2k views

### 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
...

**1**

vote

**1**answer

323 views

### Import from Folder data source missing from PowerPivot

If I look around on the Internet, I see people have the ability to import all files from a given folder:
...

**1**

vote

**1**answer

751 views

### Data Source Credentials issue with Excel PowerPivot

I am using Excel 2010 with PowerPivot. I am trying to go to the Query Editor. When I click on Table Properties, I get a password prompt:
The problem is that I don't know the password and when I ...

**1**

vote

**1**answer

402 views

### PowerPivot data feed error “Semicolon expected” during import

When importing data from an atom feed in PowerPivot, I get the following error:
XML parsing failed at line 7, column 727: Semicolon expected.
The feed currently only returns two entries, and ...

**1**

vote

**1**answer

967 views

### Excel PivotTable % of a specific value

My users have a hand built report showing tickets by time frame and their priorities.
Priority Count
1 68
2 41
3 61
N/a ...

**1**

vote

**0**answers

45 views

### 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 ...

**1**

vote

**0**answers

83 views

### 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 ...

**1**

vote

**1**answer

67 views

### 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 ...

**1**

vote

**1**answer

706 views

### Listing/grouping variables in PowerPivot table field list

I have data with 60+ variables and I would like to group the variables into different collapsible fields in a pivot table, similar to having different tables in the pivot field list - ie, instead of ...

**1**

vote

**0**answers

35 views

### Powerpivot will not install

I am trying to install 64 bit Powerpivot on a 64 bit Excel 2010 platform on a Windows 7 64 bit machine. I get an error message saying Excel 2010 must be present first, even though it already is. ...

**1**

vote

**0**answers

426 views

### How to display non-hierarchical attributes on same row using Excel Powerpivot?

Using an Excel 2013 ProPlus PowerPivot pivot table, I have the following: (+ indicating a drill-down point)
+Attribute-1
+Attribute-2
Attribute-3
Attribute-4
Below is what I would like to ...

**1**

vote

**0**answers

186 views

### PowerPivot - Your beta software has expired

I'm running the 32-bit version of Excel 2010 on Windows 7 64. I've downloaded the 32-bit version of PowerPivot from here however I get the following error:
Now I can see what the error message is ...

**1**

vote

**1**answer

328 views

### How can you improve an Excel workbook that leverages PowerPivot

I have an Excel workbook that has 30 plus pivot tables and 10 plus slicers connected to PowerPivot. When we filter data based on these slicers the performance is sub par, 30 sec to 2 minutes. Is ...

**0**

votes

**1**answer

17 views

### Change pivot table layout into “more columns”

When I create a pivot table in excel 2010 my table looks like that:
Any suggestions how to get this extra colume filled up with the names within a pivot table?
Or do I need to use power pivot? How ...

**0**

votes

**1**answer

37 views

### Setup powerpivot on a server?

I have a client that uses PowerPivot. They save the Power Pivot inside Excel files and have pivottable reports in the same Excel files.
They feel that this puts to much strain on their computers. ...

**0**

votes

**1**answer

55 views

### Microsoft Powerpivot button not working

Hoping someone can assist me with this strange Powerpivot issue; I have a single workbook which is not working with Powerpivot. It has a substantial amount of VBA code (much of which is related to ...

**0**

votes

**3**answers

75 views

### In Excel PivotTables, how do I show items that occur in one category but not another?

Simplified version of my data:
item category number
apples fruit 7
orange fruit 2
tomato fruit 3
tomato vege 9
zuchini vege 2
tomato vege 17
...

**0**

votes

**0**answers

12 views

### Power Pivot for Excel - version 11 not Installing on Office Professional Plus 2010

I'm trying to upgrade the Power Pivot for Excel add-on from version 10 to version 11, but I keep getting the error that Microsoft Excel 2010 must be installed first.
The laptop is running on Windows ...

**0**

votes

**0**answers

19 views

### How do you group by week in Excel PowerPivot?

Say you have a simple sales table in PowerPivot. What's the easiest way to allow the data to be grouped by week in a PowerPivot pivot table?
I know excel's basic pivot tables have a group feature, ...

**0**

votes

**0**answers

17 views

### How to merge Excel PivotTable results with another sheet?

I have an Excel spreadsheet, where I have a PivotTable where the X is Location & Commodity. The Y is Fiscal Year. The cell data is a sum of Commodity cost.
The PivotTable is being generated from ...

**0**

votes

**1**answer

107 views

### Two-way data update with Excel PowerPivot tables (Office 2013)

Background:
We have two excel workbooks: Data and Visual which we are using to track and visualize activities in our project. The Data file is organized like a database: each sheet is a table (which ...

**0**

votes

**1**answer

434 views

### Create a box and whisker plot in Excel 2016

I asked this question on StackOverflow as well, but I realized that this site may be more likely to produce an answer. My question is: how to create a Box and Whisker plot in Excel 2016?
I know that ...

**0**

votes

**0**answers

50 views

### Powerpivot, Calculate(SUM()) with OR Statement?

I've trying to sum a column with multiple or condition, and I haven't been able to figure out how
I could simply have multiple formulas like
calculate(sum(), filter1)+calculate(sum(), ...

**0**

votes

**1**answer

79 views

### Calculate total number of open item at each month in Powerpivot

I want to find a way to calculate the total amount of open items in each month in powerpivot. My data looks like this...
Id Team CreatedDate ClosedDate
01 AAA 1/30/2014 ...

**0**

votes

**0**answers

30 views

### Excel Powerview plot Summation of Multiple Series

Currently, I have a PowerPivot Data model based on the following table:
My corresponding data model is shown below. I have a calculated column which keeps running totals for each contractor's man ...

**0**

votes

**0**answers

112 views

### Creating Power Pivot Workbook Template

I am creating some analytics content for clients in Excel 2013 using PowerPivot. The data itself is being exported from the OLTP database to CSV files and I am importing the data in Power Pivot and ...

**0**

votes

**1**answer

218 views

### How can I make a time by date chart in powerview

I am trying to produce a report of when an event first occurs every day. I'd like to produce a line chart using PowerPivot and Power View that shows the earliest time the event occurs as a line, with ...

**0**

votes

**0**answers

58 views

### PowerPivot install cannot activate add-in

I am having problems activating PowerPivot on my colleagues' computer. While I have been able to activate successfully, 3 of my colleagues are having problems even though our hardware and software ...

**0**

votes

**1**answer

97 views

### Powerpivot; Get a datadump from SQL vs creating a data model in excel

I have a SQL table that includes sales and lead data along with detailed account information, and I have another table that just includes detailed account information.
My question is whether it is ...

**0**

votes

**2**answers

4k views

### Excel 2013 PowerPivot add-in crashes Windows 7

Running into a serious problem with little help on solving the issue. Any time I try doing anything with DAX or sometimes just opening Excel application, Excel crashes and gives me the following ...

**0**

votes

**0**answers

307 views

### Does MSOLAP.5 automatically ship when the Power Pivot addin is installed

We have been getting the following error on some user's PCs when they are trying to connect to Analysis Services OLAP cubes:
XML for Analysis parser: The restriction value provided by the
...

**0**

votes

**1**answer

39 views

### Getting #NUM! for outer nests of IF statement division

I have some sales figures for which I have values in pounds, units, and dollars. From PowerPivot, I'm creating a pivot with Periods columns (Current Week, MTD, QTD, YTD) and sub-columns of "Measure" ...

**0**

votes

**2**answers

4k views

### PowerPivot Bar is grayed out

I'm trying to begin learning to use adding measures in PowerPivot but the PowerPivot Ribbon is pretty much all grayed out. Can you tell what I did wrong? How do I get the rest of the selections on the ...

**0**

votes

**1**answer

801 views

### Calculating Annualized Turnover in a Pivot Table or PowerPivot

I'm trying to calculate employee turnover where the numerator is annualized only for the current incomplete year.
The closest I have gotten is TER/HC as a calculated Field in a pivot table. This ...

**0**

votes

**1**answer

1k views

### How to group count by week date in PowerPivot

I have a table of data in PowerPivot connected to a sharepoint list. Each row has a date that I need to group by week and count the rows in that week. Is there a DAX formula or other approach to ...

**0**

votes

**2**answers

1k views

### PowerPivot for Excel 2010 not installing on Office 2010 Home And Business

I'm trying to install Microsoft PowerPivot on a machine with a full Office 2010 Home and Student installation, and I'm not able to get the installation to work properly. The COM library will not ...

**0**

votes

**1**answer

115 views

### How to convert and Excel formula to a PowerPivot formula?

I need to convert this Excel sheet formula to an PowerPivot formula:
=IF(D3=0,"NA",B3/D3)
B3 = F5
D3 = F13
Need to add the IF to this formula:
=SUM('data'[F5]) / SUM('data'[F13])
How can I do ...

**-1**

votes

**2**answers

471 views

### Power Pivot - Average time per item

I'm trying to calculate on average, how long it takes to make each item.
Here is the data table:
Date Item Quantity Operator
01/01/2014 Item1 3 John
01/01/2014 Item2 5 ...

**-2**

votes

**1**answer

1k views

### Merging data tables to form one master table

I have multiple sheets containing a table each which I want to merge to form a master table sheet. I also need this master sheet to be updated automatically incase we make any changes to the tables ...