Forum Discussion
Solved
Slicer to change Date Columns
I'm working on a report to display productivity, as measured by orders. I have three date columns: Created, Planned, and Delivered. I want to create a single page with a chiclet slicer with values "Cr...
Hi Bobfather
Have you considered pivoting your data so instead of having 1 row with three date columns, turn that 1 row into 3 rows
eg.
ID, Created, Planned, Delivered --------------------------------
1 ,2017-1-1, 2017-1-5, 2017-1-9
ID, State , DateVal
--------------------
1 , Created , 2017-1-1
1 , Planned , 2017-1-5
1 , Delivered , 2017-1-9. This might make your task a little easier.
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHi Bobfather
Have you considered pivoting your data so instead of having 1 row with three date columns, turn that 1 row into 3 rows
eg.
ID, Created, Planned, Delivered --------------------------------
1 ,2017-1-1, 2017-1-5, 2017-1-9
ID, State , DateVal
--------------------
1 , Created , 2017-1-1
1 , Planned , 2017-1-5
1 , Delivered , 2017-1-9
. This might make your task a little easier.
Duh.... I am a master at over-complicating any problem presented to me! hahaha... Thanks so much!!!