Slicer to change Date Columns

[Bobfather]

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 "Created", "Planned", "Delivered", that would update the entire page to show each type of stats. I've looked at some similar posts (primarily https://community.powerbi.com/t5/Desktop/table-with-dynamic-values-columns/td-p/110266), but the difference is I'm trying to change which date column to filter by, rather than which column to summarize currently filtered records. Is what I want to do currently even possible, or do I just need to create three separate pages?

[Phil_Seamark · Accepted solution]

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. 

[Bobfather]

Duh.... I am a master at over-complicating any problem presented to me! hahaha... Thanks so much!!!