slicers

Hello. Can someone please help me? I uploaded my dashboard in a sharepoint/one-drive but when I open the file, the slicers are not working and I am getting this red error notice.

Dear All, I have a workbook with many sheets with multiple slicers in each sheet. I am looking for a vba code that is assigned to a button, on clicking it it should hide all the slicers and again clicking it it should unhide. The button text should change based on slicers current status...

Hello, I have created pivot tables (including measures from Power Pivot) and added some slicers, but for some reason one of them still keeps returning all of the possible results and just shows 100%. Any ideas why? See screenshot below:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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