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
2
votes
1 answer

Dynamic ranking in power bi

I have a requirement wherein, I need to get Top 5 Brands based on Sales vales in a chart. The scenario is as follows: The sample data is as below Brand Sales ----------- H 3500 B 2500 I 2200 A 1500 J 1400 K 900 E …
Sanjay_S
  • 21
  • 1
  • 2
2
votes
0 answers

Excel slicer multi-select functionality turns off when workbook is closed?

I have a workbook that contains a report with tables and slicers. Currently, when the user opens the workbook, they must manually click the "multi-select" option on the slicer. Is there a way to keep this permanently selected (even when the…
Arjun Arun
  • 313
  • 2
  • 9
2
votes
5 answers

Enable Multi-select on slicer by default

I have slicers in my workbook that I need multi-select enabled by default. I tried SendKeys. ActiveSheet.Shapes.Range(Array("WMS")).Select SendKeys "%S", True ActiveSheet.Shapes.Range(Array("Equipment")).Select SendKeys "%S",…
Justin6587
  • 37
  • 1
  • 9
2
votes
1 answer

Linked tables and Slicer in excel

I can not create a slicer in excel that filters not only by the main table, too by a secondary table that should be linked with the first table with a field key that is the reference. In other words, the main table is the students table with a…
Juan Carlos
  • 21
  • 2
2
votes
4 answers

Slicer is changing row heights of my pivot table?

I want to apply a slicer to my pivot table so users can filter easily, but whenever I select something, the row heights change. I have 'Autofit column widths on update' unchecked and 'Preserve cell formatting on update' is checked'. Any ideas would…
BH57
  • 271
  • 2
  • 7
  • 17
2
votes
2 answers

VBA to select each slicer item AND then save each selected slicer item as a pdf?

I've designed a dashboard consisting of a number of different pivot tables and pivot charts. All of these pivot tables/charts are controlled by 1 slicer called "Slicer_Store". There are about 800 different Stores to choose from in this slicer. I…
ranopano
  • 509
  • 2
  • 16
  • 32
2
votes
2 answers

VBA to connect slicers (looking for improvements to code)

I finally found a code that will connect slicers with different caches on pivot table update. Basically when the value of slicer1 changes, it will change slicer2 to match slicer1 thus updating any pivot table connected to the second slicer. I've…
Awill
  • 107
  • 7
  • 24
2
votes
1 answer

Determine the field an Excel slicer points to

I'm trying to write a macro so that when users of a workbook drill in on a pivot table, that drill in has the related slicer filters applied to the drill in results (why in god's name Microsoft doesn't already do this is beyond me). The workbook in…
JMichael
  • 569
  • 11
  • 28
2
votes
2 answers

MDX - Calculated MTD measure returning null value

I have a Cube with a Date dimension hierarchy (Year,Semester,Quarter,Month,Day). There are 2 measures available in the datawarehouse. [AUD DLY] : Daily numbers [AUD YTD] : Daily incremental YTD numbers Hierarchy is as follows Date - Dimension…
Scorpio
  • 33
  • 1
  • 8
1
vote
0 answers

How do I get my slicer to automatically update based on a data validation dropdown selection?

I wrote some code below to have my pivot table's filters (in the slicer) update when a data validation dropdown is changed. So far, this is what I have but it is not working: Option Explicit ' sheet module Private Sub Worksheet_Change(ByVal Target…
Matt
  • 11
  • 1
1
vote
0 answers

Excel pivot table slicer selection to show all pivoted columns, not only the intersection for the selected value

I want to apply a slicer for the value and show only the item where this value exists, but also show all values related to this item. Here is the sample data and the result when the value 100 is selected: Sample data and result Here is the result…
dgi
  • 11
  • 1
1
vote
1 answer

How to make value of Y-axis blank based on selected value in slicer that refer to same column that X-axis also refer to?

I have an issue I wish I would get any advice from you. I have 2 table that relates each other which are fact_table and calendar_table. I would create a simple column chart where MonthName (from calendar) as X-Axis and ValueColumn (from fact_table)…
Nur Holis
  • 31
  • 1
  • 6
1
vote
1 answer

PowerBI DAX Query - undo filter slicer on certain values based on expression

I have below table structure: enter image description here here I want to put a date slicer in Power BI to filter on dates and return the count of total rows as total in the card as shown below: enter image description here simple, the only twist is…
afotografia
  • 25
  • 5
1
vote
0 answers

How to resolve "null is not an object" issue with Reducer on React-Native?

I'm working on a React-Native project using expo and I'm facing an issue. Here is my code. This is the navSlicer navSlice.js import { createSlice } from "@reduxjs/toolkit"; const initialState = { origin: null, destination: null, …
lipian
  • 11
  • 4
1
vote
1 answer

PowerBI fixing custom start date for Date Range slicer

In PowerBI while using DateRange slicer is it possible to fix the Start Date as 01-06-2022 and End Date as today's date and still we can select older dates from the Date Range selector so that we can list records available for older dates. I did try…
Mano
  • 13
  • 2
1
2
3
…
25 26