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 ,

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