Hi Mynda
I'm progressing well with my dashboard course and have learnt a lot. I did my first one for work and everyone was impressed!
I'm currently working on a second dashboard and my pivot table has data from 2 fiscal years. This might be a basic question, but how do I ensure that my 'Month' slicer does not duplicate the months? It is showing 24 months instead of 1 set of 12 months.
Thank you, Mynda
Mei
Hi Mei,
Congratulations on your dashboard success!
I'm not sure what you mean by your month Slicer duplicating months. Can you share a screenshot?
Mynda
Hi Mynda
Here's the screenshot, Mynda
Sorry I can't share the file due to confidentiality contrants.
Thank you
Mei
Hi Mei,
Check your source data. Some of the months must have a space at the end of them or some other non-printing character that you can't see. If they were identical, then the Slicer would only list them once.
Mynda
