cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sbkrishblr Frequent Visitor
Frequent Visitor

stacked and line chart

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

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: stacked and line chart

@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,

1 REPLY 1
Moderator v-sihou-msft
Moderator

Re: stacked and line chart

@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,