Excel PivotTable is a powerful way to summarize large amounts of data and create summary reports. To make your reports more user-friendly and interactive, add visual filters, aka slicers, to them. Continue reading
by Svetlana Cheusheva, updated on
Excel PivotTable is a powerful way to summarize large amounts of data and create summary reports. To make your reports more user-friendly and interactive, add visual filters, aka slicers, to them. Continue reading
Table of contents
Comments page 2. Total comments: 47
As per slicer functions. easy to handle most critical data in full details.
This was very well done!! Thank you. It was thorough and detailed. It helped a lot.
Correction:Following up on the below*can you please let me know if there is any possibility to remove the "blank" value in my slicers or when I click the "blank" value in the slicers1-2-3, no adrees coming up in the master slicer? Thanks
Hello Svetlana,
Thanks for this platform. I have created a dashboard containing 3 slicers and a tab where I stored the data.
The logic here is that if the user select a value in each slicer, an address/addresses comes up in the master one (slicer). Imagine! the selected options are: slicer1:Europe sclicer2:Norway Slicer3:Oslo master slicer:address 1, 2..etc. I have some empty fields in my database, my problem is that when you click on ‘blank’, it does gives address, while that should not be the case. can you please let me know if there is any possibility to remove the options in my slicers or no adrees coming up in the result? Thanks
Hello,
After some filtering of the zoom on my dashboard, the slicer features such as the scroll bar and multi select/clear filter buttons are incredibly small. Is there anyway to resize these?
Hey,
Can you please let me know if there is a way to make axis in pivot chart not scale as we use slicer ?
As an example, if you use slicer for axis values, choosing only 1 item in slicer will lead to a very large 1 data column.
Is there a way to fix the scale or maybe find some workaround for mentioned issue ?
In the graph, where did the North and South parameter came from. I didn't see it from the data.
Hi Emman,
As far as I understand you are asking about an image that shows a slicer connected to multiple pivot charts, right? That chart is created for a different data set, and I've updated the visual to show the original data. Sorry for the confusion!
Very useful information.Thanks alot
Can you explain how to use a slicer selection in vlookup? I want to reference the slicer value across a difference data set to return a value.
I have used a similar feature to create dynamic Reports adjusting the slicer dates to "today' and "yesterday" (or "this week" and "prior" week"). What you need to do is create a new Table and add it to your data model, with at least two columns, one with field name: "Relative" with values: "today" and "yesterday", and a second column with field name: "Absolute" and enter the Excel functions =TODAY() and +TODAY()-1. You can then link the two data sets in your data model through fields "Date" (from your original source), and "Absolute" (from your newly created table) in your field lists. Once you have done that, create a slicer and select "Relative". You will get a dynamic slicer that will adjust automatically based on the date. This functionality should work just the same for a VLOOKUP(). All you need to do is to create your secondary table and enter your VLOOKUP() formula inside the Table.
very useful. Thanks. I was trying on the same line... but was not clear in my mind itself so I could not succeed. Now I will try. Thanks
Can we send a active slicer with graphs in the body of an outlook email. So that user can see the graph based on their filters
Hello!
To my best knowledge, it's not possible.
there is 3 column in a table and we have to marge it. we have also apply the slicer in this table. can we marge the 3 cell.
Dear Sir,
I want to know this option for show unfilter data in my pivot table
This type of option:
For example, after we select "John" in the Reseller slicer, "Cherries" in the Product slicer gets greyed out, indicating that John did not make a single "Cherries" sale:
Svetlana Cheusheva, thanks a lot for the post.Really thank you! Much obliged.