Forum Discussion
Adding Date Slicer using Multiple Date Columns
Hi Ashish,
Sorry for late reply, I was on leave and just joined work today. I'll explain below one by one:
I have this query data which i want to show on a gantt chart.
Gantt Chart will look like this:
Now on the top i want to add a date range slicer so whenever i want to select 1 Month lookahead period it will Filter all 5 milestones coming within that date range of 1 Month only.
For this i have created a Calendar which i want to use in my date slicer as i cant use any of my milestones column as it will only filter out that particular milestone and will not show all other milestones coming in that date range.
Relationships are like this at the moment and i know only one relationship can be active at a time and i don't understand how to add multiple relationships from Date Calendar Column to each of my milestone and than activate all those relationships.
I have already done unpivoting all my milestones so i can have only one date column that i could use in date slicer and it works as well but than this visual my compnay is intending to use not showing report in desired format.
These are links to files:
Please let me know if you need any further inforamtion.
Thanks,
ALI
MFelix Hi Hpe you are doing well. I have seen several posts of yours regarding the same matter. Can you please help me with this?
Hi aliawais ,
How are you?
Just to be clear you want to add a date slicer that filters the full Gantt chart for the specific month you select? So not showing any other months? basically trying to filter the gantt chart for the specific month.
Do you need to use this specific Gantt chart?
Hi MFelix ,
Thanks for responding. Yes, you are right I want to filter whole gantt chart based on date slicer dates. (One month or any other date range selected in the Date Slicer)
Reason for using this visual as my company is looking to get this visual and want us to work on it. Plus this visual gives alot of flexibility across different fields.
P.S i have already trying using unpivoting columns method and having ONE DATE COLUMN as value is also working fine in the filter but i can not use it as having my data in un pivotted form doesn't allow me to set proper parent/child nodes and this visual has some limitations on formatting parent/child nodes.
Thanks,
Ali
