Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
2 years ago
Solved

hi

Hello, i have a very silly issue    i want to see following both line of entry in power bi     if i filter by BG0000117 then i can see only that line of entry but i dont want to use filte...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    after you move columns and null value, then you need to remove duplicates.

  • abc_777's avatar
    abc_777
    2 years ago

    Hello ryan_mayu ,

     

    I tried removing the filter but cant resolved,

     

    I have changed the permission access to the folder.

     

    Please try now. just click the link and you be able to download pbix and xlxs file with sameple data. please inform me if have any issues. 

     

    If you still cant get access please share your email address (if possible) so i can email you

     

    https://drive.google.com/drive/folders/1-WQ9JQ36Rb0VqprPY6cGoWHxepdamidg?usp=sharing

     

     

    thanks

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

you don't filter in your table, you should filter in the filter visual. 

i remove empty values in the table. maybe you only provide the data with BG0000117 , if you provide more data BG0000118 or BG0000119. These data will also display in the new table.

basicly you can see the disc_type list in the filter visual in your last screenshot. Then you select the disc type to show the corresponding output.

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    don't know why ,i can't open the link, you can just skip the filter step ,just remove duplicates

  • abc_777's avatar
    abc_777
    Solution Specialist
    2 years ago

    Hello ryan_mayu ,

     

    I tried removing the filter but cant resolved,

     

    I have changed the permission access to the folder.

     

    Please try now. just click the link and you be able to download pbix and xlxs file with sameple data. please inform me if have any issues. 

     

    If you still cant get access please share your email address (if possible) so i can email you

     

    https://drive.google.com/drive/folders/1-WQ9JQ36Rb0VqprPY6cGoWHxepdamidg?usp=sharing

     

     

    thanks