Data won't show in visual

Question

Hi,&nbsp;I created a visual table from a dataset that I have. When I filter the table in my report, only 1 row appears in the filter, but the "Total" does not align with the amount in that row. I checked my dataset and I am positive that there should be a lot more rows than 1. There is no filters applied besides filtering by the category that gives me only 1 row. And what's funny is that I filtered by some other categories, the row $ amount is higher than the total $ amount.&nbsp;Any idea what's wrong?&nbsp;Thanks!Daren

cosminc · Answer

Himaybe it is a dimension with format number and is summarized?Cosmin&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous,&nbsp;Is there any chance that you can share a scrubbed version of you pbix with us so we can understand the data a little better?

anonymous · Answer

Hi&nbsp;cosminc&nbsp;,&nbsp;I've checked, nothing is summarized. The table shows the right total amount, but only 1 row is visible and that row is not even close to the amount.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;This is how my table looks like. The total is 7 digits, but only 1 row of $69 appears.&nbsp;

anonymous · Answer

Maybe this is along the lines of the problem you are dealing with? Seems like there are similar symptoms.

https://community.powerbi.com/t5/Desktop/Matrix-Total-does-not-filter-does-not-reflect-what-it-is/td-p/160043

Forum Discussion

Data won't show in visual

6 Replies

Related content

Visualizing Historical Data

Error fetching data for this visual

Export data from visual

Trello data visuals

Adding custom visual without data mapping