Forum Discussion

OKgo's avatar
OKgo
Helper IV
2 years ago
Solved

Gantt Chart with Matrix Visual

Saw this cool post and decided to try it out https://www.linkedin.com/posts/basdohmen_powerbi-design-activity-7172551962473795584-fPP_?utm_source=share&utm_medium=member_desktop   I got very close...
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    OKgo OK, this worked for me. PBIX is attached below signature:

    Gantt = 
    
    VAR StartDate = 
        CALCULATE(
            MIN(Batches[Manufacturing Date]),
            ALLEXCEPT('Batches','Batches'[Status])
        )
    
    VAR EndDate =
        CALCULATE(
            MIN(Batches[Labelled Expiry]),
            ALLEXCEPT('Batches','Batches'[Status])
        )
    
    VAR CalendarStart = MIN('Calendar'[Date])
    
    VAR CalendarEnd = MAX('Calendar'[Date])
    
    VAR ProjectPeriod = IF( CalendarStart >= StartDate && CalendarEnd <= EndDate, 1, 0 )
    
    VAR ProjectStatus = 
        CALCULATE(
            MIN(Batches[Status]),
            ALLEXCEPT('Batches','Batches'[Status])
        )
    
    VAR Result = 
        IF(
            ProjectPeriod = 0, BLANK(),
            SWITCH(
                TRUE(),
                ProjectStatus = "Manufactured", 1,
                ProjectStatus = "Plan", 2,
                ProjectStatus = "Cancelled", 3
            )
        )
    RETURN
        Result