Forum Discussion
Matrix Rows and Columns disappearing when count ID removed & unwanted grouping happening
- 3 years ago
HI, Red_prov
You may need to add the 'ID' field to the "Rows" of the matrix not the "Values".
Best Regards,
Community Support Team _ Eason
Hi, Red_prov
I am still confusing about your requirement.
Please share a sample pbix, so that we can post detailed solution.
Best Regards,
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.
- v-easonf-msft3 years ago
Community Support
HI, Red_prov
You may need to add the 'ID' field to the "Rows" of the matrix not the "Values".
Best Regards,
Community Support Team _ Eason