Forum Discussion
Helper IIIslicing effect on report
Hi MHTANK ,
I apologize for the missleading answer, the question is that since you are using data from the same table you get the data filter on the visualization and there is no option for you to remove it since the context is based on the filtered values from the diff and you cannot change the context passed to the axis individually.
For this create a new table with the months and make a relationship with the sheet1
Now redo your measure to:
stock_avg = CALCULATE(AVERAGE(Sheet1[stock_Value]), FILTER(ALL(Sheet1[Status]),Sheet1[Status]="Stock"), REMOVEFILTERS(Sheet1[Diff], Sheet1[Month]))Please see attach file.
Super UserHi MHTANK
Redo the stock average measure to:
stock_avg = CALCULATE(AVERAGE(Sheet1[stock_Value]), Sheet1[Status]="Stock", REMOVEFILTERS(Sheet1[Diff]))
Helper IIIBy that measure stock line also affect.
- MFelix
Hi MHTANK ,
I apologize for the missleading answer, the question is that since you are using data from the same table you get the data filter on the visualization and there is no option for you to remove it since the context is based on the filtered values from the diff and you cannot change the context passed to the axis individually.
For this create a new table with the months and make a relationship with the sheet1
Now redo your measure to:
stock_avg = CALCULATE(AVERAGE(Sheet1[stock_Value]), FILTER(ALL(Sheet1[Status]),Sheet1[Status]="Stock"), REMOVEFILTERS(Sheet1[Diff], Sheet1[Month]))Please see attach file.