Forum Discussion
Helper ITable in Visual do not show all records
gtamir1 Because all the data is the same it displays it as a single row regardless of the do not summarize. I fixed it using a RAND column. See attached PBIX below sig. Another way to fix it would be to add an Index column in Power Query
gtamir1 You added the Index column to your visual with Do not summarize?
Community Championgtamir1 Because all the data is the same it displays it as a single row regardless of the do not summarize. I fixed it using a RAND column. See attached PBIX below sig. Another way to fix it would be to add an Index column in Power Query
gtamir1Greg_Deckler Very interesting. I don't remember this mentioned at all.
If this was not in big numbers I wouldn't notice at all and could have inacurate numbers.Thanks
- gtamir1
Greg_Deckler Sorry, I tryed it now and it doesn't work. I am in direct query so I added an index instead of RAND.
https://drive.google.com/file/d/1rr3Z95pFlmEcMuxbTQeD_RU1c5E8pf6c/view?usp=sharing- Greg_Deckler
gtamir1 You added the Index column to your visual with Do not summarize?
- gtamir1
Greg_Deckler OK it works with the index.
Thanks