slicer items

  1. C

    return number based on 3 date entries - but one can have empty values

    Hi everybody, I am using power pivot 2016 on windows 10 enterprise. I have a data model an one of the sheets is a back order list. In this sheet I have the order creation date, the customer delivery wish date and the supplier (to us) confirmed del. date. If the supplier has not confirmed this...
  2. C

    Excel 2016 slicer item now has wrong name but refers to correct item in pivot table? Very strange

    This has to be the strangest bug I've ever seen in Excel. I created 2 slicers that control numerous pivot tables. In VBA, I check who the user is on login and then loop through the slicer names to set their name as the only one marked as true. Simple code right--the same code I have done in...
  3. J

    Using Slicers to Alter a Pivot Table

    Hi all. I was wondering if it was possible to alter a Pivot Table based on a Slicer Selection. For instance, I have a pivot table broken out by region. I would like a macro that would add a sub region if the West Region was selected, and City if the North region were selected, but if the...
  4. B

    Slicer selection based on cell value

    Hi, i have been trying for quite some time to auto select the slicers based on data validation list. for example, i have data validation list in the range I7 : I16 and I used INDEX to obtain the respective values based on selection in I7 : I16. I want slicer to select the values automatically...
  5. S

    Moving filter in PivotTable

    Hi I thought this would be simple but I can not see an option to choose which values diplay in my slicer(not results from slicer). if I have a date slicer and I only want users to be able to select the last 4 months how can I set this? Excel 2010
  6. D

    VBA code size to select slicers

    Hi All, after a bit of help to reduce the number of lines of code due to getting a procedure too large error. I have a slicer that has say approx 70 selectable options. The code basically says when a cell = something then select this slicer, however the code each time is 70 lines long as it...
  7. S

    Slicer - How to change number format?

    Hi, I'm using Excel 2013. I have added a currency column ($1.00, $1.05, $1.10, etc.) to the slicer - which represents the exchange rates that the users are allowed to choose from. The problem is that the items in the slicer revert back to general format (1, 1.05, 1.1, etc.). I would like the...
  8. R

    Pivot Table Slicers. Can I ensure one specific item is always selected?

    I'm using Excel 2013. As in the title, I have a slicer (connected to a pivot table and pivot chart) and I'd like to make sure one specific item in my slicer is always selected whilst allowing multiple others to be selected (and deselected) at will. Hypothetically, lets say the items in my...
  9. E

    Make slicer selection via Userform upon worksheet opening.

    I have a dashboard with several sheets displaying charts in various levels of drill down. While the sheets at the global level are very clear and easy to read, the sheets at the manager level are extremely busy until a Manager is selected in the slicer. Is there a way to have a userform pop up...
  10. H

    Selecting a powerpivot slicer value based on a cell value

    Hello, this is my first post, hopefully someone will be able to help. I'm having some issues in automating a PowerPivot slicer using vba. What I am trying to do is have the slicer update and only select what is in a certain cell. So for example assuming the cell was A3 then whatever was typed in...
  11. K

    Remove Fields from Slicer

    I have a Pivot Table which is driven from an OLAP database. It combines multiple sales databases across mutliple sites. We use a lot of slicers in the various views to make it quite clear what each pivot is showing, however a lot of the slicers contain a lot of old and irrelevant options...
  12. B

    Sliceritem Issues

    I'm trying to create a report that appends branch reports next to each other based on cycling through sliceritems The issue I have is that it is so slow because the pivots refresh everytime you select/deselect a sliceritem My options are as follows 1 Turn off this refresh somehow until I've...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top