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        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 .

 

  • alexei7's avatar
    alexei7
    8 years ago

    Can you add in the "IDMonth" column?

    That should split out the data

     

    Alex

4 Replies

  • alexei7's avatar
    alexei7
    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

    • rui_silva's avatar
      rui_silva
      Helper I

      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

        Can you add in the "IDMonth" column?

        That should split out the data

         

        Alex