Adding sum of categories in a slicer/legend in the line chart

[zhannak]

Hi, I've spent a lot of time trying to find the workaround for my task but couldn't do so. I have data for three categories 1,2 and 3 that I want to plot in a line chart. The idea is to be able to plot:

a) one separate curve per category

b) more curves together

c) the curve for sum of the categories 1,2 and 3

I achieved the first two goals by defining a slicer with these three categories and defining a legend in the chart with the same categories (what I mean is that the column from the data table used for the slicer and the legend in the chart are the same, which allows selecting one or more curves to be plotted separately in the graph), see example below:

However, I'm having trouble finding a way to plot the c), i.e. the fourth curve which will be the sum for all three categories (cumulative result). In the matrix visual, this is quite easy to achieve because row and column subtotals are calculated and displayed by default, whereas in the slicer it's not very straightforward. I know how to create the DAX expression/measure/column that will calculate the sum of data for three categories, but I don't know how to add it as the fourth category in the slicer and in the legend since it was not there in the original data table. 

Any ideas on what should I do?

Thank you very much for any help. 

[amitchandak]

@zhannak , check if this approach can help

Show Grand total row or Avg Grand total row in Visual: https://youtu.be/OSwRZ4GUhxc

https://amitchandak.medium.com/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be