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 project is in.

The problem is that I don't know how to display the right colour when a team name is not developed to see the projects that this team has.
What I want to achieve is e.g. one colour for all the teams when using the plus sign to not expand the rest of the rows.
At the moment, when I use the + to expand the rest of the rows, the team for which I do not expand shows only 1. I would like to replace this with one colour.
It seems to me that the problem lies in the part that is responsible for the colouring of the font and background in the visualisation, which I use in the section ‘Call elements’ -> ‘Backgound colour’ and ‘Font colour’.

Attached are screenshots of the model, measures and a link to the dummy report.
I would appreciate your help 🙂


Link to dummy report 

 

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

13 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    1 year ago

    Hi Konrad909090 
    if i understood you correctly and you are looking for the option to apply conditional formatting on the row header

    then unfortunately we don't have this functionality, the conditional formatting cam be applied only with the "values" section.
    There is an idea about the issue, you can vote for it here :
    https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=81d13d9e-0b12-ee11-a81c-000d3a0ec312

    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 for answer.

      I would like to hide the values when a row is not expanded, or set one colour for all collapsed rows.
      After expansion, I want them to look as they currently do.
      Blank


      Or with color

       

      Best regards 
      Konrad

      • Ritaf1983's avatar
        Ritaf1983
        Super User
        1 year ago

        Hi Konrad909090 
        You can manipulate the values that are shown according to the hierarchy level using the function is in scope.
        You didn't attach data to work with , so I will show how it works with my example :

        This is my matrix 
        Country << category on rows.
        Year<< month on columns.
        Total sales on values 

        To keep a country level blank I can create a measure :

        Blanks_ = if(ISINSCOPE('Products'[Category]),[total_sales],"")
        The formula says that if I am not on the category level show total sales and on the country level keep it blank.
        The result :

         

        the pbix is attached

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