Forum Discussion

Andy85Stam's avatar
Andy85Stam
New Member
2 years ago
Solved

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?

2 Replies

  • maybe you can try to fill down in the power query

     

     

  • Anonymous's avatar
    Anonymous
    Not 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.