Data Table help

[ye348]

Hi im trying to figure out how to get my visuals to work with the data I have currently I tried making it work using the matrix visual but im still missing one key part.

so ill explain whats in the data: for the rows I have two different sets of data one is the title of the item and one is the trade or company of which all the items belong to (this part is fine and im having no issues here)

for my column I just have a simple date range to serve as the column headers.

the problem is the values i want to get a visual where the dates in the "values" part of the chart visual can just be displayed as their own regular values but the chart only gives me the options of earliest, latest, count, etc.. and none of these options work for what im trying to get out of this visual. Im not sure if maybe theres a different visual I should reference but I essentially want something that will allow me to display the dates i have in the "values" part of the chart as the plain dates themselves, no earliest or latest, etc...

[Ashish_Mathur · Accepted solution]

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.

[ye348]

actually that  makes perfect sense, im looking through my dates right now and your correct, even with the aggregation it wont make a difference since im only trying to display one single date per item

[v-linyulu-msft]

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.

[ye348]

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?