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

Konrad909090's avatar
Konrad909090
Helper II
1 year ago

HI Ritaf1983 ,

Thanks again for the reply and the solution provided.
I used the ISINSCOPE function. Unfortunately in my case all the values disappear.
I think I am following the logic given in your pbix file but I am still not able to achieve what I want.
I have attached a link to the file in the first post. I can't upload the file directly in the message, I get a message that these types of files are not supported on this form even though you uploaded yours.
So I am providing a link to google drive with my file again.
If you have the time and inclination, I would appreciate it if you would take a look at it.

https://drive.google.com/file/d/1YT8YZAa2KyeFfH0njMCwEvxEHc-If-SY/view?usp=drive_link

Ritaf1983's avatar
Ritaf1983
Super User
1 year ago

Unfortunately, there is no access to the file ...you need to share it with the option "everybody who has a link"

    • 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.