Data won't show in visual

[Anonymous]

Hi,

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.

Any idea what's wrong?

Thanks!

Daren

[v-frfei-msft]

Hi @Anonymous ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Anonymous]

Hi @Anonymous,

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]

Hi @Anonymous 

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

[Anonymous]

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...

[cosminc]

Hi

maybe it is a dimension with format number and is summarized?

Cosmin

[Anonymous]

Hi @cosminc ,

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.