Pitan here! In Part 3 of my PowerPivot blog series, I cover how to add slicers to a PowerPivot report.
This post covers how to format slicers in Excel 2010 – in particular, how to create a custom slicer style that can be applied to multiple slicers.
But you may find it easier to clone the style and then modify the style properties, which is what we will do in this example. Here is the slicer with the unmodified clone of the style:
Right-click on the style that you want to clone and modify. Select Duplicate.
Slicers always display all the values available from the field, regardless of whether there is data available for that value. When modifying slicer styles, you can set custom formatting for whether a slicer has associated data or not.
Starting with the “Whole Slicer”: you can set properties that…drum roll please…apply to the whole slicer. You can set font and fill properties, but for this example I just changed the border color to be black.
Next I changed the header to have a black background and bold white font. These formatting options are pretty much the same as formatting for basic cells in a worksheet.
I did the same for Selected Item with no Data, but I used lighter colors for the gradient. I left the Unselected Item with/with no data colors the same, since white with black or gray seemed fine.
Slicers also can display custom formats when a user hovers over a particular value. Again, the formatting can change depending on if the slicer item has associated data or not. The slicer style I cloned used consistent formatting for hovering over all items.
And that’s how it’s done!