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
2 years ago
abc_777

pls see the attachment below
invoiceno.pbix27 KB
ryan_mayu
2 years ago
after you move columns and null value, then you need to remove duplicates.
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

Solution Specialist

2 years ago

Hello ryan_mayu

Here i have given more sample file to pbix file

please use this.

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

instead of filtering

thx

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

Forum Discussion

hi