cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Continued Contributor
Continued Contributor

Re: Power Bi Filter data automatically

Can you add in the "IDMonth" column?

That should split out the data

 

Alex

View solution in original post

4 REPLIES 4
Highlighted
Continued Contributor
Continued Contributor

Re: Power Bi Filter data automatically

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

Highlighted
Helper I
Helper I

Re: Power Bi Filter data automatically

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

Highlighted
Continued Contributor
Continued Contributor

Re: Power Bi Filter data automatically

Can you add in the "IDMonth" column?

That should split out the data

 

Alex

View solution in original post

Highlighted
Helper I
Helper I

Re: Power Bi Filter data automatically

@alexei7 Thanks !

 

Rui Silva

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors