Table visualization returns different number of rows depending on the column order

[RafalK]

Hi,

I have an issue in my report.

Depending on the column order in the table visual, it returns a different number of rows.

Can this be an expected behaviour or should I consider this as a bug?

The table has 4 columns. Different arangement of those returns 1, 2 or over 100 rows.

When I look at the DAX queries they differ slightly. Due to query complexity and privicy I will not post them here.

Regards

[PhilipTreacy]

Hi @RafalK 

The number of rows displayed could be affected by the aggregation applied to the column(s) or the measures you are trying to display.  Check what is applied.

Hard to say any more without actually seeing your data.

Phil

[RafalK]

Hi Philip,

I do not change anything except the order of column is the visual. All aggregations stay the same.

[PhilipTreacy]

Hi @RafalK 

Very difficult to help when I can't see the data/PBIX file.

I'm happy to look at this if you want to send me a private email via the forum with a link to your PBIX file.

Regards

Phil