Forum Discussion

rui_silva's avatar
rui_silva
Helper I
8 years ago
Solved

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    ...
  • alexei7's avatar
    alexei7
    8 years ago

    Can you add in the "IDMonth" column?

    That should split out the data

     

    Alex

rui_silva's avatar
rui_silva
Helper I
8 years ago

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's avatar
alexei7
Continued Contributor
8 years ago

Can you add in the "IDMonth" column?

That should split out the data

 

Alex