Forum Discussion

Walt1010's avatar
Walt1010
Icon for Helper V rankHelper V
1 year ago
Solved

Missing Visuals after Append

I've copied a table and filtered it down to 1 row. Then I appended this row and the original table into a new table. The table view ahows the table with all the data, but the any visualisation doesn'...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Walt1010 ,

     

    We are sorry to hear that you are experiencing this issue with Power BI Desktop. Here are a few steps you can try to resolve this issue:


    1. Please try refreshing the data in the new table.


    2. Please check if there are any relationships that may affect the visualization. If the new table has incorrect relationship with other tables, it may not be displayed correctly. Also, check if there are any filters applied to the visualization that may exclude the new data.


    3. If the visualization uses measure or calculated columns, make sure they reference the new table correctly.

     

    If these didn't solve your issue, please share more details about it in a screenshot or a pbix file (with sensitive data removed) so that we can better help you solve the problem.

     

     

    Best Regards,

    Clara Gong

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

Walt1010's avatar
Walt1010
Icon for Helper V rankHelper V
1 year ago

Thanks for your reply. As soon as I saw it I began methodically working through all the measures that I used in the report, and I soon relaised that I had several that still referenced the "parent" table and not the one that was the result of the append. Once I changed them the visuals worked fine. Thanks again.