line graph - add line based on slicer selection(s)

[swhite77]

I have a line graph that spans the last 13 months and has two slicers.

I'm displaying the cost-of-goods% (COGS) based on the selection in the first slicer (State = Colorado)

The second slicer is all the law firms included for the State.

I'd like to add/remove lines (Blue line in attached prototype) to my graph based on selections made in the second (Law Firm) slicer so I can compare how this law firm is doing compared to the overall State values.

[swhite77 · Accepted solution]

I figured out how to do this.

One simple measure to figure COGS for the law firm.

And a second measusre COGS for Region % = CALCULATE([COGS for LF%], ALL(FileEntry[Law Firm Name])).

It was easier than I thought.  Have already identified where I can use similar functionality.