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,
I have a table with a lot of detail in a visual.
The table in data section is ok, for example for column "No Pedido" I have 18 registered data as "001-07" as I show in the first image.
But when I create the table as a visual and applying "don't summarize" in all the collumns, some data is summarized, for example the "001-07 have just 15 records (as shown in the second image).
Thanks so much in advance
Solved! Go to Solution.
Hi @eduardosilvin2 ,
The 'don't summarize' means that the field/column will not be aggregated (count, sum, first, last, etc) but will not stop other non-aggregated column from not being repeated like as shown in the data view. The workaround is to add a column with values that are always unique per row (values that don't repeat in any other rows) like an index column. Of course, I'd change the value color of the index column as well as that of the header so they blend with the background (eg white text on a white background).
Proud to be a Super User!
Hi @eduardosilvin2 ,
The 'don't summarize' means that the field/column will not be aggregated (count, sum, first, last, etc) but will not stop other non-aggregated column from not being repeated like as shown in the data view. The workaround is to add a column with values that are always unique per row (values that don't repeat in any other rows) like an index column. Of course, I'd change the value color of the index column as well as that of the header so they blend with the background (eg white text on a white background).
Proud to be a Super User!
So simple and effective, thank you so much, not only gave me a solution but you explained it. Really appreciate it.
Regards
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |