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.
Questions tagged [slicers]
377 questions
1
vote
1 answer
Power BI - Slicer Color change based on data value
enter image description hereenter image description hereI want to change the tile color of a horizontal slicer based on a table value. I.E. if the data value in a table is > 0, format the slicer tile to change color.
In my report I use a simple…
Russell Anderson
- 13
- 1
- 4
1
vote
1 answer
Power BI From and To Date Filtering with One Slicer
I've a simple (hope so) question.
I've got a table where I have a start date column and an end date column.
I can add two slicer to filter the period, but I would like to filter with just one slider, like shown on this video…
1
vote
0 answers
Dynamic Excel vba to make selection of dates in slicer
I would like to write a code where the scope of dates is set between startdate (today +1) and enddate(today + 21)
after trying to record scoping the slicer it created the following code(see below)
Maybe there is an solution to refer to 2 cells to…
Thom Haasert
- 119
- 7
1
vote
3 answers
Microsoft Power BI - DAX - tricky situation involving ALLSELECTED in slicer
I have a situation below in Power BI and DAX language.
I have 2 simple tables:
CountryTable
YearTable
There is a 1-M relationship between YearTable and CountryTable.
The latter (Year) is used to feed values into a slicer.
The former (Country)…
user3812887
- 439
- 12
- 33
1
vote
0 answers
Group Dates in Google Sheet Filter
is there any way I can group dates of a report in Google Sheets?
The difficulty that comes along is that this is a report that updates automatically every 4 hours (Salesforce connector).
When I add a slicer/filter option it shows me all the…
A.Be
- 73
- 5
1
vote
0 answers
Multiple Fact Tables Slice one table with second table categories
I looked around A LOT but could not find the answer, I'd appreciate some help here!
I have a data model with 2 fact tables: [A] Product Sales & [B] Expenses Per Product Per Channel.
I need to report based on the Sales [A] so my goal is to be able to…
Tomas Moreno Plese
- 11
- 1
1
vote
1 answer
Using one slicer (Date) with two different tables and two different data columns
I have several tables in my data model.
Among others I have the table
"Sales" (with all sold products by customer, date and marketing source) and the table
"Media Spend" (with all marketing sources and their budget per month).
TABLE…
Florian
- 47
- 1
- 4
1
vote
1 answer
Automatic Slicer Selection VBA
I am trying to automate my dashboard as efficient as possible. For that i need my slicer to automatically select this month and the previous month.
Currently it manually updates by a different macro for every month, which deselects everything except…
Gino Bianchi
- 21
- 1
- 4
1
vote
1 answer
Power BI Slicer on one table not fitering joined table
My relationship between two tables looks like this:
I use a single select slicer that filters the table [ExhibitorClass_Details]. But it is not filtering the joined table [EventMax_Details]:
Why does my slicer not filter the joined table, what…
Johnny Spindler
- 358
- 4
- 14
1
vote
1 answer
How to make interactive filter in power bi between 2 pages (not slicer)
I have a case where I have to make interactive filtering on few sheets.
Explanation:
suppose page 1 and 2 have part_nbr field in filter pane and both of the pages have matrix visual in it.
i want to make the interaction between this filter of both…
Amit
- 11
- 4
1
vote
0 answers
Slicer selection in Power BI
I am trying to replicate the following calculated field that was done in Tableau to a Measure in Power BI:
From Tableau:
IF [Period]=#2018-01-25# THEN
(IF [Parameter Value]='Non-profit' THEN (IF DATEDIFF('month',[pol_date],[Period])<=2 and [non prf…
dda
- 143
- 6
1
vote
2 answers
GoogleSheets - Slicer on Pivot Table
I've created a pivot table and added a slicer which works fine
However I want to use the slicer on a different sheet (dashboard control)
But when I place the slicer on a different sheet (I tried copying the original slicer as well as creating it…
Michael Liew
- 273
- 3
- 12
1
vote
0 answers
Count of KPI from different tables based on date
I have the following 4 tables and i want to show the count of ID's for each KPI's for each Caseload (1,2,3,4 etc ) something like in the second picture.
I am not sure what is the correct method but i've created a date table and use as slicer because…
mihaita_baro
- 9
- 1
1
vote
1 answer
How can I loop through excel pivot slicers using python win32?
I am trying to loop through all the slicers and then export it to PDF. I am having trouble looping through the Slicer Items.
I have tried the following,
items = ['abs', 'abc', 'abd', 'cdc', 'dvd']
for each in range(0, len(items)):
itemSlicer =…
Aishwarya Prabhu
- 73
- 6
1
vote
1 answer
Complex date trouble in powerbi
I don't figure out how to manage my problem with a unique simple date slicer.
I have a table with contracts begin and end date joined with a dimensional table Dates.
I would like to count contracts over the period using this slicer.
I would like to…
Jonito
- 407
- 7
- 18