I have a matrix that lists open tasks broken up into categories. So the user is able to expand these different pools to see what kind of tasks are still open.
In order to hide the data unless the matrix was expanded/drilled all the way down i used this formula
I believe i found why the grouping is happening. my last row in my BI report is the id related to the individual request that can have multiple tasks tied to it. i am using that to display the record information. so in instances where multiple tasks are tied to that same ID that fall into this section its not displaying them individually. just grouping based on the id.
However in ssrs its just displaying the requestID in the record/row information and not using is as a grouping.
however excluding this ID i dont get the same visual
however when movingthe requestID from row to value section in the powerBi visual it doesnt display all records that fall into the previous category like ssrs above. it just tosses them in an aggregate so sum/count whatever for the column value
I am still confusing about your requirement.
Please share a sample pbix, so that we can post detailed solution.
Community Support Team _ Eason
Hello, i am attempting to upload the test pbix/xlsx however i am gettig a red banner saying the file types arent support.
I can post screenshots of both
Above is the test data. i have 4 records, 3 related to 1 reqID, while the others standalone.
When expanding the matrix i want to see all records. however i have not found a way to setup the matrix yet to allow this.
I will work on getting a sample file working to display my concern later today.
But just to try to clarify in the mean time. i have a matrix with the rows listed above. You can expand the matrix to the requestID level. However in doing this. when expanding a category if the level your expanding would have multiple entries for the request id. instead of listing them out multiple times it groups them into the same count. when expanding the matrix to the last detail level. if i have 4 records i want them all listed individually. Howeve it appears that the matrix is grouping them together instead of listing them out. Referencing the first screenshots i attached. when fully expanded if the count is greater than 1 it has multiple task strings. so its empty due grouping. instead of that grouping i want them to be listed individually. But if i dont use the requestID as the final row level. the matrix doesn't display the data in the same format, and it also aggregates the rows displaying counts. when fully expanding application category as the final drill through i want to show all records listed. not group some so they arent visible.