Excel Slicers containing Year and Month - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 8
Netty
This is smart! I have to figure out the date range for my AR aging report. By adding the period, I'd be able to do the analysis easily and get the -as of date- based on the Period. Thanks! :-)
reply
This is smart! I have to figure out the date range for my AR aging report. By adding the period, I'd be able to do the analysis easily and get the -as of date- based on the Period. Thanks! :-)
reply
Alfredo
Hello, great idea but what about if instead of having only 2 years, I have 10 years, the slicer would have 120 rows. Would it matter? Would it be the right approach in this situation?
reply
Hello, great idea but what about if instead of having only 2 years, I have 10 years, the slicer would have 120 rows. Would it matter? Would it be the right approach in this situation?
reply
James
I am trying to do WEEKS and MONTHS. But when I use Days - 7 I can no longer add years, months etc. Is the only way to add a new column in my data for week number?
reply
I am trying to do WEEKS and MONTHS. But when I use Days - 7 I can no longer add years, months etc. Is the only way to add a new column in my data for week number?
reply
sarosh
Hello, I have discovered you today and already watched an hour of your videos. Could you please tell how can we break the dates into quarters instead of months?
reply
Hello, I have discovered you today and already watched an hour of your videos. Could you please tell how can we break the dates into quarters instead of months?
reply
Supun
Once I updated the dashboard, year slicer automatically disappears & the pivot diagram also crashes. Could I have a solution for this matter?
reply
Once I updated the dashboard, year slicer automatically disappears & the pivot diagram also crashes. Could I have a solution for this matter?
reply
Brandon
don't have to adjust the bottom of the view field -Up- you can right click and select -Slicer Settings- and then -Hide Items with No Data-
reply
don't have to adjust the bottom of the view field -Up- you can right click and select -Slicer Settings- and then -Hide Items with No Data-
reply
Adam
when you refer to --Date-, it automatically calculates for everything in that column - very cool. How do you get it to do that?
reply
when you refer to --Date-, it automatically calculates for everything in that column - very cool. How do you get it to do that?
reply
Eray
I was stuck in the middle of an analyze which aims to compare to numbers year base. This one helped me a lot. Many thanks
reply
I was stuck in the middle of an analyze which aims to compare to numbers year base. This one helped me a lot. Many thanks
reply
Add a review, comment
Other channel videos
