Forum Discussion

Zyg_D's avatar
Zyg_D
Continued Contributor
7 years ago

Showing full data in table visual (including duplicate rows)

I have 12 rows of data:

I can put them into a Table visual like this:

The great thing which I like over Tableau is that rows become as high as needed, while Tableau only allows fixed row height. This is a very useful feature.

The question is, is it possible to show a full table? You can see that duplicate rows from data (data has 12 rows in total) were removed in the visual (only 6 data rows remain). 

Need Help
Show and Tell

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Zyg_D best option woudl be to add index column in your model, you can easily do it in advanced editor in power query and drop index column in your table and the you will get to see all the rows.

    • Zyg_D's avatar
      Zyg_D
      Continued Contributor
      7 years ago

      Is it possible to hide this index column now?

      P.S. Using Advanced Editor is not easy. It doesn't even have "undo" functionality. I messed up in some changes that I did, and there was no option to remove the step. So I was forced to load my data again from scratch. Imagine if I was working on my actual project...

      I added index numbers using Edit Queries... > Add Column tab > Index Column > From 1

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Zyg_D you can make col size very small and also change background and foreground color the same so that values are  not visible .