Hello
I have large data in table in many columns
I need Slicer for Time Column or TimeLine for Time Column without using of PivotTable
How can I get that without PivotTable ?
in the attach file in the left side I have main column for time, when I insert slicer for that it is useless for me
for main column I need slicer something like Result Table Slicer or right side
Thank you in advance for your help
Last edited by soubasa; 07-28-2023 at 06:31 AM.
Hi,
insert a new column and extract a date with the format you need then insert a slicer to that column.
For tables, Timeline is not available
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Thanks for your time
in your file when I select Dec 2022 just show me Dec 1, 2022 not all days of Dec 2022
other months have this problem too
many thanks in advance for solve this problem
Thank you for your time
My problem solved by below formula :
=DATE(YEAR([@[Signal Time]]), MONTH([@[Signal Time]]), 1)
Of course, I was inspired by you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks