slicers

  1. tazeo

    Efficient Keyword Searching with PowerBI: Tips and Tricks for OR Results

    I often find myself sifting through large amounts of data to identify relevant keywords, and as many of you may know, this can be a time-consuming and sometimes frustrating process, particularly when it comes to spelling errors. To address this issue, I came up with the idea of using PowerBI to...
  2. S

    Excel Slicer #N/A error

    Hi I have a Excel formula for selecting items from a Slicer. But when I select more than what is in the formula 1-11 the result is #N/A. I want my formulas to allow me to select Months and Display what has been selected or ALL when no selection has been made. Same with selecting Models...
  3. A

    VBA scripting: looping through slicers and 1 item in each

    I'm working on an automation of my Excel file by using VBA. I'm not experienced at all, but I'm learning OTJ. We have a file containing a PivotTable which has been converted to OLAP Cubes. We use 35 slicers (with two options, only one of which is needed) on the worksheet to have information...
  4. C

    Setting vertical axis in dynamic pivot charts and slicer button positioning without VBA

    Hi Excel Gurus, After a week of googling, reading and trying. I am giving up to ask the experienced members of the community to please help me out. I am using a pivot chart slicers with dynamic charts with multiple outputs. 1. How do I force the vertical value axis to be the same for each...
  5. E

    Slicer not working on Chart in VBA, but works after selecting chart data manually

    I created a VBA script that adds charts and slicers to my worksheet, but for some reason they don't work after adding them. Now, once the charts and slicers are added I would go and select on the chart, right click and click "select data" then click ok. Once I do that the slicers work with the...
  6. E

    How to add multiple slicers to same worksheet using VBA

    Hello, I am trying to add multiple slicers to the worksheet, but my code is only adding either one or the other. Each slicer has a different pivot table coming from different worksheets within the workbook. How could I get it so that when the below code executes both slicers are added to the...
  7. C

    How to select Slicer Items with items in array

    Seen a lot of posts with this question, but no working answers yet. I have a sheet with a number of pivot tables in Excel, which are controlled by one slicer to set a specific filter. I'm able to abstract the Slicer Items with a VBA function found on the internet: Public Function...
  8. B

    Macro to clear all slicers except one

    Hello, I'm working with a table with many slicers. I want a command button that will clear all the filters from the slicers, but keep the 'year' slicer as is. Any help would be appreciated. I'm quite new with VBA, so please make it really obvious what parts of the code I should be substituting...
  9. E

    Setting up a dashboard with a data source that can be updated by copy/pasting data into a different sheet

    Hi! I've essentially built a dashboard that has many slicers, allowing users to select various requirements and view which IDs are applicable to the given selection. I've built this dashboard via a macro, so that the user can just re paste the needed data into a sheet, click a button with the...
  10. L

    VBA Populating SmartArt and demoting nodes

    Hi all! Have to start with a big thank you! I have learnt so much from this forum and wish to contribute in some way in the future! I have been lurking far to long with out creating an account. To the problem at hand: I'm building a tool to follow up activities/tasks I have a table (tabell1)...
  11. Z

    Slicers and relationships not working

    Hi all I need some assistance please, I have a dashboard, where I have a date slicer, which is filtering fine on tables with a date, however, I have a staff list table which doesn't have a date to create a relationship with, but I am using the staff table in order to calculate how many people...
  12. H

    Problem with Pivot tables and slicers..

    Hi, would there be a workaround for this dilemma - I have a pivot-table with a list of customers. To this table I attach a slicer showing the customers names. All work fine when selecting the client name from the slicer - but in certain cases it is easier to filter the pivot itself - and in such...
  13. A

    Pivot Table Recognizes Empty Cells with Formula as with Data

    Hi guys, I have a pivot table in which my filter in it recognizes some cells with formula in them as if they are data (the cells shows nothing with help of IF and "") hence the slicers include an empty box which does not amount to anything. I want to avoid or remove this box somehow this but...
  14. L

    Sorting number of tables via 2 slicers to pull data onto a dashboard

    Good day to everyone on mrexcel i hope you can all help me with a complex issues I have.. I'm trying to create a dashboard, for our CCG and GP. So that they can select which CCG and if they want data on the CCG or GP or both. Via the use of 2 slicers. These slicers then have to filters...
  15. S

    Pivot table with multiple slicers, need a search box

    Hi, I have a power pivot table with 6 slicers. Date, invoice number, vendor and so on. but I have over 3000 invoices and to scroll takes to long and is hard to do. rather than using each slicer to filter the next and narrow the list. I would like to use the search box to find the invoice...
  16. Bagharmin

    Changes in Timeline don't affect Slicer

    I have a Timeline and some Slicers connected to a pivot table. The pivot table uses data obtained via Power Query and loaded to the data model via a connection only (I'm probably not saying this entirely correctly). Whenever I change the Timeline, the changes are reflected in the pivot table...
  17. D

    Excel Table Slicer - 1 slicer for each subcategory

    Hi Everyone, The short question would be this: Is there a way to insert slicers for each of the subcategories from a Pivot table? To expand the question and give you a bit more details: I'm working on updating the UI for an excel sheet with a long list of columns that contain information about...
  18. S

    Copy slicers

    Is there a quick way to copy slicers to all sheets at once rather than sheet by sheet?RegardsStephen
  19. N

    Create Multiple Tabs based on Slicers

    Hi, I want to use a macro to create multiple tabs based on a slicer. The sheet will have all the other slicers and also graphs based on the particular slicer. I have 3 graphs and 4 slicers - the slicer which I want to use to populate the tabs is countries. So each country has their data on a...
  20. S

    Link Multiple Slicers (into one)

    My slicers are using different tabs for sources, so they won't link in the report connection. I once created a massive slicer that would edit any slicers you attached to it without using the report connection feature. Although, for the life of me, I cannot remember how I did this. Any...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top