Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rui_silva
Helper I
Helper I

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 .

 

1 ACCEPTED SOLUTION
alexei7
Continued Contributor
Continued Contributor

Can you add in the "IDMonth" column?

That should split out the data

 

Alex

View solution in original post

4 REPLIES 4
alexei7
Continued Contributor
Continued Contributor

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

alexei7
Continued Contributor
Continued Contributor

Can you add in the "IDMonth" column?

That should split out the data

 

Alex

@alexei7 Thanks !

 

Rui Silva

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.