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
6
votes
4 answers

Report connections for Pivot table slicer doesn't show all pivot tables?

I have 3 sheets with several pivot tables on each and one sheet with the source data. These 4 sheets were copied directly from another workbook. When I copied the worksheets over the source data for each pivot table was still the original source…
Sorath
  • 543
  • 3
  • 10
  • 32
4
votes
2 answers

Pause VBA until #GETTING DATA Power Pivot is complete

I have an Excel workbook with a large Data Model connected to two slicers. I need to cycle through every entry in the slicer, allow the workbook to catch up on loading a large number of cube formulas, then copy one particular worksheet over into…
OldKingCole
  • 115
  • 12
3
votes
1 answer

Speeding up add/remove PivotTable to Slicer VBA

I have a workbook that has a number of Pivot Tables spread across a number of worksheets. There's a bunch of slicers on one of the worksheets, and they're pretty slow-ish to load after changing filters/selections. All of my slicers are on the same…
bigsim
  • 132
  • 8
3
votes
1 answer

Using Date Range from a Slicer in a DAX Query PowerBI

I have a date slicer that is controlled by the user. I am trying to use the users min/max date selection as a indicator. I have created two measures - one for the min value and another measure for the max value. Please see DAX code for one…
Daisy
  • 121
  • 1
  • 9
3
votes
0 answers

set default value for slicer in power bi

in a power bi report, I wanna set a default filter in the slicer. the slicer contains different branches and I wanna set a special branch as default when the user opens the report. can you help me to set the default value for the slicer? I have…
Zahra
  • 317
  • 4
  • 16
3
votes
2 answers

Change Slicer "Name to use in formulas"

I have create some slicers connected on a pivot table and now i want to change their "Name to use in formulas". Any help will be appreciate.
Error 1004
  • 7,877
  • 3
  • 23
  • 46
3
votes
0 answers

slicer list in excel and python

does anyone know how to handle slicer list in excel from python. I´m working with some excel files, and one of them have some slicer list. When i run the next code from openpyxl import load_workbook wP…
Carlos Arronte Bello
  • 419
  • 1
  • 7
  • 20
2
votes
1 answer

Latest values by category based on a selected date

First, as I am a French guy, I want to apologise in advance for my poor English! Despite my searches since few days, I cannot find the correct measure to solve my problem. I think I am close to the solution, but I really need help to achieve this…
AntoineG37
  • 21
  • 2
2
votes
1 answer

Is it possible to generate an Excel with Slicers with Python? And with the XlsxWriter library?

I would like to be able to incorporate Slicers (access buttons to column filtering options) in the Excel sheet from python code. Would there be any way? I would like to start from this code: import xlsxwriter workbook =…
Ekimus
  • 23
  • 2
2
votes
2 answers

Measure or column filtered by a relationship and a slicer

I have a table Deals which has columns [DealId], [Open Date Id], [Closed Date Id] where the last 2 columns are like a foreign key to the Date table which has [Date], [DateId] column. Power BI won't let me have 2 active relationship, so one is…
nomel3
  • 23
  • 3
2
votes
1 answer

Use Power BI Slicer to Filter Columns

I would like to allow users to be able to filter the Power BI bar chart with the following options: GDP only (see only Country A, B, C GDP data only when GDP is selected on slicer) Population only GDP and Population my current data structure(in…
avidLearner
  • 23
  • 2
2
votes
1 answer

How do you change the data Color of a line chart in Power BI based on Slicer Selection

I have a table of selections that has no relationship and only serves to be a selector for a filter: I then have this feed a slicer on my page so that when the user selectes a value, the following measure will evaluate (works great): Metric Toggle…
SQALEX101
  • 209
  • 1
  • 3
  • 16
2
votes
3 answers

Remove hidden slicer

Due to the application of the slicer of the sheet, the slicer itself, that was on the right side of the first data rows of the table disappeared from my view. How can I get it back or simply remove it? I can create a new one, but I didn't find how…
Thomas B
  • 181
  • 1
  • 13
2
votes
0 answers

Macro fires 50% of the time when changing slicer item

I have a particular problem and couldn't find any solution anywhere on the internet. So I have a pivot table which is connected to 6 slicers and also a chart which data range is dependent on pivot table values. I've made a macro which updates chart…
Alan K
  • 81
  • 7
2
votes
1 answer

Excluding Multiple Slicers when clearing all slicers using VBA

I have a set of slicers that I need to clear, excluding 2 slicers which need to remain as whatever is selected. The code I am currently using allows me to exclude 1 of the slicers from the clear, but I cannot find the correct way to exclude the 2nd…
M Bennett
  • 21
  • 1
1
2 3
…
25 26