Forum Discussion

hyugo_v's avatar
hyugo_v
Helper I
7 years ago
Solved

evolution in column

Hello everybody,   i'm currently working with power bi on a mission currently but i'm facing a problem which i still can't resolve, i put in attachment the illustration on what i will talk now.   ...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi  hyugo_v ,

     

    Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

     

    Best regards

    Amy

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi hyugo_v ,

 

For the FILTER condition, you can create like DAX below, then you can select the table of "net start " and " finish date ".

 

FILTER(ALLSELECTED('Table_Wavegraph'),'Table_Wavegraph'[NET START]<=MAX('DateKey'[Date])&&'Table_Wavegraph'[FINISH DATE]>=MIN('DateKey'[Date]))

 

Could you please clarify or show your desired output, such as in which visual ,which field on X axis, which field on Y axis?

 

Best Regards,

Amy

hyugo_v's avatar
hyugo_v
Helper I
7 years ago

Hi v-xicai ,

 

the formula you said is right ! i didn't type it correctly, i have indeed a visualisation which is closer to what i want,

 

to answer the question you asked, i want in the X axis the evolution in time (1/Apr/19, 8/Apr/19 etc...) and in the Y axis the sum of ETC of the projects as we see just above the dates in yellow (3123, 2835 etc...) 

 

Which normally leads to a visualisation like as follow, your formula looks really correct but i don't find the good value yet, however it's getting closer :) sum of ETC (Y axis) through the time (X axis)

  • hyugo_v's avatar
    hyugo_v
    Helper I
    7 years ago

    v-xicai, 

    i got a visualisation like this, i'll try to find why i got different values, until now thank you for your help :) 

    • v-xicai's avatar
      v-xicai
      Community Support
      7 years ago

      Hi  hyugo_v ,

       

      Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

       

      Best regards

      Amy