disaggregated Data

[Ramalhomarcelo]

Hi everybody

I’m trying to create a table and, I don’t know why, I can’t disaggregate all the rows.

In the database, I have 7 rows with the same id, date,  description and value and I want that the table contains all the 7 rows. Instead, the table aggregate the information and only appears one line with the amount.

What I want

Id	Date	Descr	Value
1029	17/07/2019	345	750.00
1029	17/07/2019	345	750.00
1029	17/07/2019	345	750.00
1029	17/07/2019	345	750.00
1029	17/07/2019	345	750.00
1029	17/07/2019	345	750.00
1029	17/07/2019	345	500.00

What I have

Id	Date	Descr	Value
1029	17/07/2019	345	750.00

Noted that in the setting I have already set the variables to “not summarize”.

In order to overcome this issue I create a function “row_number”  but with this function my importing data settings through to “import” instead direct query”

Do you have another solution to this issue?

Thanks

[TeigeGao · Accepted solution]

Hi @Ramalhomarcelo ,

Based on my researching, it is still not supported to display the Duplicate data in Table visualization, as a workaround, we can create an index for this table in Power Query:

Best Regards,

Teige