So I have a data model that I have built in Power Pivot that contains numerous pivot tables. All of the pivot tables are filtered using slicers, and for some reason, there are a few pivot tables where the slicers are not working. I have all the relationships built in the model, and nothing has changed. I don't understand why it isn't working. There are no error messages of any kind, the worksheet is not protected, and refreshing the pivot table would not overwrite any data in the worksheet. I have tried deleting the pivot table and creating a new one, but when I do that, it won't even let me choose a slicer. The dialog box comes up, and I can select a field to use for my slicer, but when I click on it, nothing happens. Is this a common problem?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Slicer not working in Power Pivot model
- Thread starter cmgish
- Start date
Excel Facts
How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Similar threads
- Replies
- 4
- Views
- 447
- Replies
- 0
- Views
- 498
- Replies
- 5
- Views
- 483
- Replies
- 4
- Views
- 528
