Showing multiple lines in a line graph based on filter

[Anonymous]

Hello all,

I have a database involving IT ticketing. I have a table that has every IT incident, when it occured, who it was assigned to, and the user group it affects. 

Right now, I have a line chart showing the number of incidents over time (shown below). I also have a slicer for user groups (eg. IT Tier 1, IT Tier 2, IT Systems Admins, etc). 

When I select multiple groups from the slicer, it affects the line chart as expected and keeps it as one line. What I want to do is when 2 or more user groups are selected, show a separate line for each of them on the same chart (as shown below).

However, to get the second line chart with multiple lines, I had to put user groups in the legend. If I do that, then when no groups are selected, it shows a line for every single user group. There are almost 100 user groups so I do not want a separate line for each if none are selected in the slicer. I want a single line when no groups are selected.

Thanks everyone!

[v-luwang-msft]

Hi  @Anonymous ,

What is your base table structure? Generally with this kind of line chart, you need to have a type field that serves as a slicer value for filtering.

Best Regards

Lucien

[Anonymous]

Yes I know, I created that line chart by adding "user group" to the legend. The table has each IT incident, when it occurred, who it was assigned to, and what user group it belongs to. User group is my slicer that I created. I can create each line chart just fine. My question is whether I can keep it as a single line when no "user group" is selected from the slicer, and multiple lines when multiple "user groups" are selected from the slicer.