Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |