Forum Discussion
Data Table help
Hi,
If there is only 1 date which falls at the intersection of the row and column header, then the aggregation function (such as max or min) will not make a difference. If there are multiple dates, then what result do you want to show - all in the same cell with a comma seperator? You may use the CONCATENATEX() function. To receive further help, share some data to work with and show the expected result.
Hi, ye348
Thank you for reaching out to the Microsoft Fabric Community Forum. We appreciate you sharing your user experience with us. Based on your case description, I understand how frustrating this situation must be for you.
Nevertheless, according to our measured results, I feel regretful to inform you that it turns out to be a by-design one.Because the matrix itself is an aggregate type of visual object, even if the values in the matrix are unique, it still requires an aggregation method. This is consistent with your test results.
If you want the values not to be aggregated, I suggest you try implementing it in a table visual object.
1.First, here is my test data:
2.Secondly, select the column you filled in the column section to pivot:
3.This way, you can choose not to aggregate the value.
I hope these steps help you achieve your goal. If you have any questions or need further assistance, please feel free to let me know!
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i guess im haveing trouble following along, because the "values" that i dont want aggregated are just part of a single column in one of my tables so im not sure i follow exactly how your doing it. do you know of any other visuals that would allow me to display data the way i explaining earlier?