The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Format Slicer

Format Slicer

Super Learner
0
Votes
1
Answer

Hi Tutor, 
I’m having fun with the course and the materials is very useful. 
I got a question on the slicer format. 
In the last video (This is how the report can be used in practice by high-level executives) of Intro to Excel. You showed a formatted slicer without the “(blank)” options for each slicer. How can I create a slicer without the (blank) option?
Many thanks.

1 Answer

365 Team

Hi Jacky,
You need to right click on the slicer to open ‘slicer settings’ . From there you can opt for ‘hide items with no data’.
This should help.
Best,
Ned

×
LAST CHANCE
Ready to Learn Data Science?
50% OFF