Forum Discussion
Columns not displaying data in Report View
So I've dropped a number of column headings into a report for a roster I'm creating but the table won't display the data under each heading.
I've checked the sources in Power Query and the data in the Data View as well, but there's nothing that stands out. Not sure what's throwing it off...
Hi Alta88 ,
I am glad that you could solve your problem. Please kindly Accept the helpful reply or your workaround as the solution. More people will benefit from it.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Are these columns from different tables? At least one of them will be an aggregation (SUM, COUNT etc.) and it looks like there is no combination of those columns which produces a valid (non-blank) aggregation.
--
Start off the visual with all the columns from the same table and see if the visual populates
No, they're all from the same table. This very bizarre and I'm wondering if there's a bug in the report.
Hi Alta88 ,
According to your statement, you can see underlying data in Power Query Editor and Data View. So I think your connection mode should be Import mode.
Please make sure you can see your data in Power Query Editor and Data View again.
Please make sure there is no other filters in other level filters like Page level filter, this will casue that you couldn't see data.
Please update the desktop version to the latest version and load your data into desktop and try again.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, Rico. I spoke w/ my supervisor about it and it appears that since the report is a copy of an original report it screwed up the way data was displaying. He advised I save the original report as another file name and work on it that way. I tried that and everything is displaying properly now. Thanks for your insights, though.
Hi Alta88 ,
I am glad that you could solve your problem. Please kindly Accept the helpful reply or your workaround as the solution. More people will benefit from it.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
