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

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

    Happy to help 🙂