Forum Discussion

RafalK's avatar
RafalK
Advocate IV
5 years ago

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

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

Need Help

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    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's avatar
      RafalK
      Advocate IV
      5 years ago

      Hi Philip,

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

      • PhilipTreacy's avatar
        PhilipTreacy
        Super User
        5 years ago

        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