Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |