Forum Discussion

sbkrishblr's avatar
sbkrishblr
Frequent Visitor
8 years ago
Solved

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

 

 

 

  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    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

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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,