Power Bi Filter data automatically

[rui_silva]

Hi,

Im  trying do report where i need to compare some data from different months. But my powre bi is filtering duplicates rows where i have the same id.

Sample data:

IDClass  IDMonth ClassName        nStudents

1                1                ClassA               30

1                2                 ClassA               25

2                 1                 ClassB              27

2                  2                ClassB               27

When i try to filter my data only to "Class A" in my chart the data will be aggregated instead of being separeted showing the values .

[alexei7]

Hi @rui_silva,

I don't understand your issue.

Your sample data is helpful. Can you also display:

1) the unwanted results you are getting

2) the results you actually want

Thanks

Alex

[rui_silva]

So the currents results im getting in char is :

Use slicer to filter 2 months "January and Feb" and Class A

and in my chart appears :

IDClass  ClassName  nºStudents

1               ClassA          55

And i want to appear as 

IDClass  ClassName   nStudents

1                ClassA         30

1                ClassA          25

[alexei7 · Accepted solution]

Can you add in the "IDMonth" column?

That should split out the data

Alex

[rui_silva]

@alexei7 Thanks !

Rui Silva