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

abc_777's avatar
abc_777
Solution Specialist
2 years ago

out put is same that u have given is correct but issue is in your pbix file you filter by BG0000117 

 

 and i dont want to use filter here as my BG0000117  will be change to BG0000118, BG0000119, BG0000120 etc etc ......

 

i have duplicate value in disc_type and invoice column and i remove null, remove duplicates, remove blank then create relationshio with sales table invoice_no and new Table Invoice_no many to one its ok but the result is not comes , result shows 

 

 but i want to see 

 

like this

 

 

thnakx