Forum Discussion

TristanO216's avatar
TristanO216
Frequent Visitor
7 years ago

Avoid filtering cumulative sum

Hi, I am trying to make a progess curve, using a cumulative sum. The point is to obtain a percentage of the finshied tasks over the total number of tasks. This is easy using "Quick measures"; and t...
Need Help
TristanO216's avatar
TristanO216
Frequent Visitor
7 years ago

Hi v-cherch-msft,

 

Thanks for you answer but that's not what I am looking for.

My "Progress" value must not impacted by the filter imposed by the slicer, contrary to the other data on my visual.

Some pictures will help me to explaine what I am looking for :

Here I have the complete period of time. The progress is starting at 0%, and ends at 100%,.

After applying a filter in time, my progress is still beginning at 0% and ends at 100%.

 

My goal is that my progress curve follows the actual value, based on the 2015-2019 period, and not on the only on the 2016 period.

 

Thanks for your help

Tristan

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi TristanO216 

    Show a simple sample here.You may try to create a Month table and use it as x-axis.Create the second same data table to get the sales.Link them as below.Then the different slicers could change different lines.Please refer to below attached simple file.

    Regards

    • v-cherch-msft's avatar
      v-cherch-msft
      Microsoft Employee
      7 years ago

      Hi TristanO216 

      Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

      Regards,