Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |