Forum Discussion
Advocate IHow set a dates range to filter a Gantt projects
Hi all,
thank you for your attention.
I use a Gantt Cart (by MAQ sw) to show all projects in my work team, I need to filter them by a dates range to select all projects which days (between 'FromDate' and 'ToDate') are in in the interval.
I don't know if PowerBI has the ability to get in input two date ad use this by and advanced filter formula to perfor the achieved filter.
Below a hand made screenshot to explay what a need to implemnet.
Thank you!
Giuseppe A.
2 Replies
HI pinoaino ,
Power bi slicer not support filter across multiple date fields. In my opinion, I'd like to suggest you to add a calculated table to expand detail records between two date field and link to original table.
Then you can use this bridge table date field as source of slicer with 'between' mode to filter date range.Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
MAQSupportSolution Supplier
Hello pinoaino ,
To display the projects between a specific interval you can have two slicers: ‘Start date’ and ‘End date’.
As shown in the below screenshot, one slicer is for start date and one for end date:
Configure ‘Start date’ slicer to filter dates after the mentioned date:
Configure ‘End date’ slicer to filter dates before the mentioned date:
The projects for the selected interval will be displayed.
For any further queries, please feel free to contact us [email protected]
Thanks.
