Forum Discussion
gtamir1
Helper I
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_...
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?
Greg_Deckler
Community Champion
Community Championgtamir1 You added the Index column to your visual with Do not summarize?
gtamir1Helper I
Helper IGreg_Deckler OK it works with the index.
Thanks