Forum Discussion

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

It is hard for me to understand.

Could you provide more information?

For example:

Which columns are in your table? "ActualEndDate", "milestones"?

 

Then you add "milestones " in a slicer, right?

 

"2 horizontals bars for count of milestones" , does this refer to a column chart?

you add "milestones" in the Axis field and  "ActualEndDate" in the Value field, right?

 

Best Regards

Maggie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have different milestones with actual end dates, I need to count volume of milestones based on my selection, If I select multiple milestones M2, M5,M7 It should give me count in a stack graph from M2 to M5( eveything in between also), M5 to M7 based on my x-axis which is actual end date.

So the problem I am stuck is to generate dynamic count everything in between M2-M5,M5-M5. 

Note: user can select multiple milestones anything between M1-M10 and some milestones can also get added in near future too.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous

    How many milestones do Users need to select? More than three?

    For example, select M1, M3,M5,M7?

     

    Best Regards

    Maggie 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes user can select any number of milestones but the result should fetch all data in between. Example- for Selection M3, M7,M9 the result should be everything from M3 to M7 and everything from M7 to M9