stacked and line chart

[sbkrishblr]

Hi,

currently i am using two meausres in stacked y axis and one measure in line chart. and x axis is the time line.

every month, two measures A & B are stacked one above the other. and other measure C is line axis which plotted along the time line X axis.

we have a requirement to slice/filter the measure B for some categories within that. some how i can filter the measure B for any one category, but alwasy the measure A & measure C would remain C. the slicing and filter should be only for measure B.

But i need the measure B to show the groupings/slicing in it self.

Thanks,

Suresh K

[v-sihou-msft · Accepted solution]

@sbkrishblr

In this scenario, you can fix the category filter within Measure A and Measure C formula. For example, your Measure A is calculating total on Column A, and you have a Category selection in a slicer, you can write your Measure A like:

Measure A = CALCULATE(SUM(Table[Column A]),ALL(Table[Category]))

Regards,