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 filter for BG0000117

just simple wnat to see both line in visual

thanks

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

Super User

maybe you can try to create a dim table which contains two columns

BG0000117 and data in first column

then you create relationship between two tables.

when you filter BG000017 in the dim table. you can see two lines of your original table

Solution Specialist

Hello

Thanks for your reply. would mind to help me with a pbi file with this sample data

Thanks

Forum Discussion