Forum Discussion

aliawais's avatar
aliawais
Frequent Visitor
4 years ago

Adding Date Slicer using Multiple Date Columns

Hi All,   I'm trying to add a Date Range Slicer to my Power BI Report so every week when i'm producing 4 weeks lookahead report i just have to change dates using date range slicer. I have 5 differe...
Need Help
Show and Tell
MFelix's avatar
MFelix
Super User
4 years ago

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?

aliawais's avatar
aliawais
Frequent Visitor
4 years ago

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

  • aliawais's avatar
    aliawais
    Frequent Visitor
    4 years ago

    Hi MFelix ,

     

    Hope youa re doing well. Did you get any solution?

     

    Thanks,

    Ali