cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
renmello
Helper I
Helper I

Gantt Chart Matrix with tasks hiearchy

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 workingThe gantt with the Modulo workingAs soon as i expand to the next level (entregas) it goes wrongAs soon as i expand to the next level (entregas) it goes wrongHere is with the lowest level  (Tarefas)Here is with the lowest level (Tarefas)


1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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. 

041601.jpg

Hope this helps.

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

View solution in original post

2 REPLIES 2
renmello
Helper I
Helper I

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

v-jingzhang
Community Support
Community Support

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. 

041601.jpg

Hope this helps.

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

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors