Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
61 | |
61 | |
55 | |
38 | |
27 |
User | Count |
---|---|
86 | |
61 | |
45 | |
41 | |
39 |