How do I create a linechart that allows me to compare two teams overtime based on the active counts

[SammuelM]

Hello.

Please, How do  I create a linechart that allows me to compare two teams overtime based on the active counts?(I want all teams on one slicer if possible, and no more than two teams for comparison at a time).

... ... ... ...

Teams	Year	month	active
A	2023	1	15
B	2023	2	24
C	2023	3	12
D	2023	3	45

[Ritaf1983 · Accepted solution]

Hi @SammuelM 

You should put the team on the legend:

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @SammuelM 
It sounds like your slicer is modified for "single select".

You should switch this option off for choosing multiple teams.

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[SammuelM]

I most cerainly did. I even updated my Power BI desktop app.  

[Ritaf1983 · Accepted solution]

Hi @SammuelM 

You should put the team on the legend:

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly.

[SammuelM]

@Ritaf1983 

It's not working for me. I can only select one team. please advise

Thank you

[Ritaf1983 · Accepted solution]

Hi @SammuelM 
It sounds like your slicer is modified for "single select".

You should switch this option off for choosing multiple teams.

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[OguzMavice]

Hi @SammuelM ,  

Could you please check your slicer settings? in order to choose one more item in the slicer you should select below feature;

[Ritaf1983]

Did you download the pbix that i attached?

[SammuelM]

Hi. I did. 

But I just want to limit to two at a time in the slicer. it selects more than two in my case

[Ritaf1983 · Accepted solution]

Hi @SammuelM 
There is no option to limit the number of selections.

It is 1 or unlimited.
There is an idea about this issue, you can vote for it here :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=6c3d3501-e910-ee11-a81c-00224853a463

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly