Forum Discussion
Power Bi Filter data automatically
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 .
Can you add in the "IDMonth" column?
That should split out the data
Alex
4 Replies
- rui_silvaHelper I
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
- alexei7Continued Contributor
Can you add in the "IDMonth" column?
That should split out the data
Alex