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.
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 .
Go to Solution.
Can you add in the "IDMonth" column?
That should split out the data
View solution in original post
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
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 Thanks !
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.