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

[SammuelM]

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

[Ritaf1983]

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]

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]

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