Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Problem with Week Num in Gantt Chart using Matrix

Hi, I have a problem with the customized Gantt using Matrix that are wrongly plotted in the Week Number portion.

Given with the Date and the Projects Table respectively,

     

projects 1 through 7 should belong to week 1, projects 8 through 14 should belong to week 2 and only project 15 is starting on week 3.

 

However, when I started to plot them into the matrix with the measure to plot the dates,

I get the undesired plot in my Matrix chart.

 

Is there something I miss with my measure or with how the date table is coded?



Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    Can't quite see what your problem is, but you can refer to my method and it works fine. 

    A calendar table has no relationship between fact table. I think this is what amitchandak means.

    New measure to identify if the day contained in that week.

    Measure =
VAR _p_d =
    CALENDAR ( MAX ( 'Table'[start date] ), MAX ( 'Table'[end date] ) )
VAR _c_d =
    VALUES ( 'calendar'[Date] )
VAR _if_in =
    COUNTROWS ( _p_d ) - COUNTROWS ( EXCEPT ( _p_d, _c_d ) )
RETURN
    IF ( _if_in > 0, 1 )

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      What do you mean by independent date table?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

     It seems that this a bug from power bi

     

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Community Support
      4 years ago

      Hi Anonymous ,

       

      Can't quite see what your problem is, but you can refer to my method and it works fine. 

      A calendar table has no relationship between fact table. I think this is what amitchandak means.

      New measure to identify if the day contained in that week.

      Measure =
VAR _p_d =
    CALENDAR ( MAX ( 'Table'[start date] ), MAX ( 'Table'[end date] ) )
VAR _c_d =
    VALUES ( 'calendar'[Date] )
VAR _if_in =
    COUNTROWS ( _p_d ) - COUNTROWS ( EXCEPT ( _p_d, _c_d ) )
RETURN
    IF ( _if_in > 0, 1 )

      Pbix in the end you can refer.

      Best Regards

      Community Support Team _ chenwu zhu

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.