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