Forum Discussion
Helper ITable in Visual do not show all records
In the transaction table there are multiple records. I want to show all filds in a visual.
Records which are duplicate appear only once.
All fields are marked as "don't summarize".
For example id_Deal 10227400
Here is a link to a short sample:
https://drive.google.com/file/d/1rr3Z95pFlmEcMuxbTQeD_RU1c5E8pf6c/view?usp=sharing
Any idea, thanks Giora
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?
5 Replies
- Greg_Deckler
Community Champion
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
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?