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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.