Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 .
Solved! Go to Solution.
Can you add in the "IDMonth" column?
That should split out the data
Alex
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
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
Can you add in the "IDMonth" column?
That should split out the data
Alex
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |