slicer

If I have a slicer with a column ID containing e.g. 1. 1.01 1.02 1.1 2 2.1 2.2 How can I filter that slicer to only show whole numbers but if 2 is selected also show 2.1/2.2

Hi, Is it possible to have a slicer from one table controlling another, I've essentially set up 3 small tables a date table (marked as such in pq) a product table and a sales table, all are linked. and I like a slicers from the date and product tables to control the pivot table showing...

Hi all, I currently have a list that looks like this (albeit much much much larger in reality): I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...

Fairly new to excel. I have created a pivot table and organised it to display what I need. When creating a pivot chart, when I create a slicer I cannot filter the data/rows I want to view. It may be that I need to add something to the raw data or that I need to change my pivot table/chart...

Hey, I have an excel table with invoices. Invoices has two dates, one is the date of completion, the other is the date when the invoice was actually paid. I need two different charts from this. One that shows revenues according to the first date, and one that shows revenues according to the...

Hello, I have a pivot table and my values are mostly based on calculated fields. I want to make a slicer based on the values so that it will only show based on slicer filter. Can someone help me please? Appreciate the help!

Hey all, I have tried searching for the answer for this problem and I can not seem to find the answer that I need, so was hoping that you guys could help. I have created a workbook that we use within my work that shows what every member of staff is working for any given hour they are at work...

Hello, I have a problem, I have create a little pop up window where there are two slicers. This pop up window is actionable by clicking on a button using bookmarks. So the user will click on the button that enables to open the pop window after he chooses some informations in the slicers and...

Hi, I am using the below VBA to export to pdf based on a slicer. The main problem is that it is selecting those slicers that are not visible (no data). How can I have a loop with only visible slicers? HELP PLEASE! Sub Reporte() Dim sC As SlicerCache Set sC =...

Hi, I need some help with a spreadsheet that I cannot change the source data (raw data), which is extracted from a report. Basically, I need to identify the products with highest satisfaction rating among a plethora of products, in a single column with data that goes from smartphones, tablets...

I use the following code to clear slicers from my PT: Sub clearSlicer() Dim pt As PivotTable Dim cache As Slicer For Each pt In ActiveSheet.PivotTables For Each cache In pt.Slicers cache.SlicerCache.ClearAllFilters Next cache Next pt End Sub How can I accomplish the same...

I have two data sets with a column named identically that has very similar text values. I am having trouble creating a relationship between the two in Power Pivot and I keep getting this error "(String Review)Relationship between '*****' and '*****' is a many-to-many relationship which is not...

Hello All I am new to VBA programming. I have an Excel workbook with two worksheets - one containing raw data and the other containing a pivot table and corresponding slicers for it. My requirement is to use VBA to dynamically choose particular options in the slicers and copy the resultant...

I feel extremely dumb right now, but I have some slicers that I have done something to and now I cannot reposition them. I can select them but they cannot be moved or resized. I have unprotected the sheet and checked the format Slicer properties and nothing is locked. What are the ways to lock...

Hello, I am trying to create a slicer-controlled excel line chart. Where you can select one series or more within the dataset to display on a line chart. I'm able to create a pivot table and even a slicer but I'm having difficulty trying to put everything together. Does anyone have any...

Hello, I have been using this code (look below) to create a Slicer for my Pivot Table, which is located at Worksheet_One. The Silcer's name is "My_Slicer_Date" It works well but I would like to use the same code to create the same Slicer but for another Pivot Table, which is basicaly same...

I have a multiple calculated fields in my excel pivot table. The field is in the values part of my pivot table and I sum them. I want to add a slicer to select them or not. i.e. I want my slicer to select basically hide and show AA1,AA2,...,AA8 in the chart and table. This is normally easy if...

I have a data source with sales data by store. Columns in this data include actual sales, forecasted sales, week date, weekending (saturday), region for the store, and which warehouse the store received the sold items from. I need to create a matrix visualization in which the user can filter the...

Hi, I've have CUBERANKMEMBER formulas to list items selected in a slicer. How can I list items NOT selected? Example: ="TOP 25 BY MODEL "&", LOCATION "&CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer_loc_code_ClassSales,1)

Hi Guys, i want to make excel pivot table slicer generate text in a cell when any slicer is chosen. Is it possible for me to do that? Thanks