Forum Discussion

Konrad909090's avatar
Konrad909090
Helper II
1 year ago
Solved

Imitate gantt chart using Matrix visual.

Hello experts, I am trying to build a solution to imitate a gantt chart using matrix visualisation. The gantt is to display the duration of the project and the colour depending on what stage the pr...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    Hi Konrad909090 
    Modify the conditional formatting for "Values and totals"

    + if you want the colors of the top row stay when expended , switch on the sub-total per team level:

    Result :

    Modified pbix is attached

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

Ritaf1983's avatar
Ritaf1983
Super User
1 year ago

Hi Konrad909090 
I update your formula to 

Gantt Value =
VAR ProjectStart = MIN('Projects'[Start date])
VAR ProjectEnd = MAX('Projects'[End date])
var result=
    IF (
        AND
            (
                MAX('Calendar'[Date]) >= ProjectStart,
                MIN('Calendar'[Date]) <= ProjectEnd
            ),
            1,
            BLANK()
    )
    RETURN
    if(ISINSCOPE(Projects[Project name]),result,"")
And it seems that there is a result as you wanted :

The updated pbix is attached

 

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

Konrad909090's avatar
Konrad909090
Helper II
1 year ago

Thank you for your help.
It's strange in your version of the report I can't see the colours when the teams are rolled up.

Additionally the colour shows for all years on your screenshot.

In addition, the team ‘Yellow’ shows but I can eliminate it after by applying a filter.

However, this is more or less what I want to achieve. I just don't know where the problem now lies with the display of colours when the teams are collapsed.



 

 

  • Konrad909090's avatar
    Konrad909090
    Helper II
    1 year ago

    Hi Ritaf1983 

    Thank you very much, this is exactly what I wanted to achieve.
    You have saved my day today 😄
    THANK YOU VERY MUCH AND HAVE A NICE DAY 😄

    Regards
    Konrad

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    1 year ago

    Hi Konrad909090 
    Is this a wanted result?

    If yes, than all manipulations with isinscope are a part of conditional formatting.
    For a background :

    Colors =

    IF( [Gantt Value] <> 0 && ISINSCOPE(Projects[Project name]),
    SWITCH(
        MAX('Projects'[Stage number]),
        4,"#3982A7",
        3,"#B832AC",
        2,"#881176",
        1,"#BA545B",
        0,"#DC7455"
    ),
     IF(isinscope('Team'[Team]),"#ffdbbb"
        )
    )
    For a font color:
    Font color =
    if(ISINSCOPE('Projects'[Project name]),"black","#ffdbbb")
    The updated pbix is attached

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




  • Ritaf1983's avatar
    Ritaf1983
    Super User
    1 year ago

    Happy to help 🙂

  • Konrad909090's avatar
    Konrad909090
    Helper II
    1 year ago

    Hi Ritaf1983

    Thank you very much for your continued attempts.
    We've almost got it, but when rolled out, one team shows the colours and the other only shows ‘1’.

     

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    1 year ago

    Hi Konrad909090 
    Modify the conditional formatting for "Values and totals"

    + if you want the colors of the top row stay when expended , switch on the sub-total per team level:

    Result :

    Modified pbix is attached

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