Solved: Rolling 6months on Gantt chart - Page 2

Anonymous · ‎10-22-2020

Hi

Is it possible to get solution for my requirement in power bi? I tried in all the ways still not able to find solution so seeking expert suggestions.

I am using Gantt chart (imported) and have columns Start Date and end date, product name, activity name. I have start and end date in my slicers as well. When I select start date as 1/1/2020 my Gantt chart has to show from selected date to 6months ex Jan 2020 to June 2020. If user selects end date as 1/8/2020 then Gantt chart has to show Mar2020 to Aug2020. If user selects between range that range only has to show and default start date is current date and end date is 6months.

If user selecting more than 6months then have to show popup message or error message saying that pls select 6months.

I don't have any measure here. And most important thing is start and end date both are coming from same table. I tried with disconnected table but everyone used measure in the existing posts which I got from Google.

v-lionel-msft · ‎10-27-2020

Hi @Anonymous ,

Try to redefine the start date and end date based on the slicer value to determine the range.

__start date = 
VAR x = SELECTEDVALUE(Sheet4[End Date])
VAR __year = YEAR(x)
VAR __month = MONTH(x)-5
VAR __day = DAY(x)
RETURN
IF(
    __month < 0,
    DATE( __year-1, __month+12,__day),
    DATE( __year, __month, __day)
)

__end date = 
VAR x = SELECTEDVALUE(Sheet4[Start Date])
VAR __year = YEAR(x)
VAR __month = MONTH(x)+5
VAR __day = DAY(x)
RETURN
IF(
    __month > 12,
    DATE( __year+1, __month-12,__day),
    DATE( __year, __month, __day)
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Rolling 6months on Gantt chart

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly