Stack Overflow
Stack Overflow

Questions tagged [slicers]

Slicers provide buttons that you can click to filter PivotTable data in Excel. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered PivotTable report.

377 questions
-1
votes
1 answer

Slicer Value/Item selection through Excel VBA

I would like to know the VBA code to select the one item at a time in the slicer. Actually I have a slicer with 10 items in it. I also recorded the macro to see the code. In that code, it makes true the item that I want to see and all others as…
Ali
  • 1
-1
votes
1 answer

Excel dashboard using slicers when cell contains multiple values

I have a problem with creating the dashboard in excel. My data is about sales, clients, meetings. One of the columns contains the type of transaction (for example: AAA, BBB etc). Usually for each row there is one type of transaction, but in some…
ArthurMorgan
  • 69
  • 7
-1
votes
1 answer

ignore slicer value for only on column

I have a table where it show nr of clients per practitioners. and a slicer from a Date table. THis is the table i want to drill through IAPT Clients to another table ( see below ) and be able to see the Cient ID and All Sessions and Eligible Session…
mihaita_baro
  • 9
  • 1
-1
votes
1 answer

Registration MR and CT images in 3D Slicer

I want to overlap the MR and CT images in 3D Slicer, but since the CT image I have is cut from the lower part of the nose, many structures in the MR image do not correspond to the CT, so the registration process cannot be performed completely. What…
Berrin
  • 1
-1
votes
1 answer

Power Query map one column from a table to three columns of another table

I am working on a dashboard for Netflix movies/series. I have a table A with columns as shown - I need a Genre Slicer on the top of dashboard to filter movies of that genre. I am thinking of making an another table B with column Only_Genre such as…
Shaikh Naushad
  • 53
  • 1
  • 9
-1
votes
1 answer

Merge Sort Counter Slices

I have a general question regarding slices, counter, time and the baffling merge and sort in Go. I have coded a little program from a practical exercise online to learn about Go, I'm baffled as to why the solution I have written gets an error. The…
General Zaroff
  • 13
  • 1
-1
votes
1 answer

How can I edit the VBA script to save to specific folder depending on the slicer selected

I have developed a Dashboard which changes based on 2 slicers: Department and Employee. My ultimate goal is for the attached code to run on the selected department's in the slicer and the 2nd slicer will have all the employees selected, then the…
PrChica
  • 1
  • 2
-1
votes
1 answer

Google Sheets: Enabling Slicers

It was announced on Aug 1st of this year that Slicers have been added to Google Sheets: https://gsuiteupdates.googleblog.com/2019/08/sheets-slicers-scorecards-themes.html. This is supported by their updated docs here:…
user3871
  • 12,432
  • 33
  • 128
  • 268
-1
votes
1 answer

Add slicer into VBA UserForm

I am wondering how can I insert the slicer into the userform after creating the pivot table in excel 2016. Inserting slicer means clickable slicer, not image.. Could anyone show me some example vba code? Thanks in advance
Yung Lin Ma
  • 121
  • 2
  • 14
-1
votes
1 answer

Slicers in PivotTables showing incorrect items

File at the bottom. I am trying to create dashboard in Excel 2010 using PivotTables and Slicers. I am creating 5 different PivotTables from same data source. The dashboard will have 5 slicers, of which two of them changes each PivotTables and the…
Mateusz Szczepek
  • 1
  • 2
-1
votes
1 answer

Create VBA for selecting a slicer selection

I want to use my excel and pivot data as a template. Therefore, all linked data to pivot tables and slicers are emptied when the template is created. After generating the template my slicer setting is lost. Is there any way to make a mandatory and…
Zahra Zamani
  • 1
  • 1
-1
votes
1 answer

Filtering doesn`t work on three level dimension

can someone help me out maybe? I have the following mdx: and the following structure of the Relationship dimension: And when in excel I try to filter on the attribute hierarchy: User Story Team, it only works for the two level user hierarchy…
Lena Meer
  • 79
  • 9
-1
votes
1 answer

Excel - slicers copying each other

I have an Excel spreadsheet which is split down the middle and mirrored on the other side so I do comparisons. I have the same slicers on both sides but when I change one slicer the other changes too. Is there a way to make the slicers independent…
Dean Flaherty
  • 33
  • 8
-1
votes
1 answer

Or criteria on PivotTable via Slicer?

I have a mind-bender here. There is a PivotTable with two columns representing Doctors. So the first column heading is Doctor_1 and next to it is Doctor_2. Each line in the pivot table represents an interaction between two doctors. Like, one…
tbur
  • 2,384
  • 1
  • 13
  • 12
-2
votes
1 answer

creating new table based on slicer selection in power bi using DAX

I am new in Power Bi, so if anyone help in the following scenario then it will be very helpful for me. suppose i have two tablse as Table 1 = Name A B C and Table 2 = Sl. No Name 1 A 2 B 3 C Now, I will put Table 1 in…
debashis bhowmik
  • 1
  • 1
  • 2
1 2 3
…
25
26