Gantt Chart Matrix with tasks hiearchy

[renmello]

Hello, I am trying to create a gantt chart with using a matrix, following this topic:

https://community.powerbi.com/t5/Community-Blog/Think-inside-the-box-Custom-visuals-using-Standard-V...

I was able to replicate it, but my model has hiearchy between the tasks. 

The issue i am facing is that it works as long as i am not using the drillthrough in the matrix. Example: if i am showing the lowest level, only the selected level shows the gantt, the levels above keep returning the number one. The row of the higher levels should follow the lowest level.
 
I am using three tables for the tasks hiearchy and the order is: Modulos  (column modulos)-> Entregas_Programas (column programas) -> Tarefas_Programas (column NomeDaTarefa)

I am using the dax formula from the topic and following the instructions:

Usage User =

IF (

(

MAX ( 'calendar'[Date] ) < MAX ( Tarefas_programas[DatadeIníciodaTarefa])

|| MAX ( 'calendar'[Date] ) > MAX ( Tarefas_programas[DatadeTérminodaTarefa] )

),BLANK (),

1

)

There are below three prints from the challenge i am facing 🙂 I would be glad with any help!
The gantt with the Modulo workingAs soon as i expand to the next level (entregas) it goes wrongHere is with the lowest level (Tarefas)

[renmello]

Hi! @v-jingzhang , thanks! It worked 🙂 

[v-jingzhang · Accepted solution]

Hi @renmello 

You found a great blog! I learnt a lot from it!

For your problem, you can select Apply to Values and totals when formatting the background and font colors. Otherwise it selects Apply to Values only by default. 

Hope this helps.

Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.