cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Zyg_D Frequent Visitor
Frequent Visitor

Showing full data in table visual (including duplicate rows)

I have 12 rows of data:

data.JPG

I can put them into a Table visual like this:

pbi2.JPG

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

4 REPLIES 4
Super User
Super User

Re: Showing full data in table visual (including duplicate rows)

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





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




Zyg_D Frequent Visitor
Frequent Visitor

Re: Showing full data in table visual (including duplicate rows)

Is it possible to hide this index column now?

image.png

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

Zyg_D Frequent Visitor
Frequent Visitor

Re: Showing full data in table visual (including duplicate rows)

@parry2k  - Is it possible to hide this index column?

Super User
Super User

Re: Showing full data in table visual (including duplicate rows)

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





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.