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

      • 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