Forum Discussion
Andy85Stam
2 years agoNew Member
Excel to PowerBi
Hi all a newb here so be gentle!
I've linked my data to an excel document to show a weekly daily check and giving a pass/fail and then % overall see below
But when i add the data to power bi it only shows as
It wont show the other 3 names. Do i need to add the date next to each entry or is there a simple fix?
maybe you can try to fill down in the power query
2 Replies
- ryan_mayuSuper User
maybe you can try to fill down in the power query
- AnonymousNot applicable
Hi Andy85Stam
After my testing, when you put the Name column into the table, the other three names won't disappear.
Make sure you have not misused filters that could cause your data to be lost.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.