Forum Discussion
Anonymous
6 years agoNot applicable
Matrix don't summarize and show values
Hi, I'd like to show values in a matrix and not a summary or a count. I just want to show the values. On the left, I've a matrix and on the right, I've a table. I'd like the values to be sho...
Anonymous
6 years agoNot applicable
Hi Anonymous,
I'd like to suggest you create a matrix visual with 'category' and 'name' to rows, 'year' to the columns, 'should', 'current' to values and drill each category fields to 'bottom' level to expand all records.
If your records still summarize, you can consider add more row categories and drill them to split summarize records values.
Drill mode in a visual in Power BI
Regards,
Xiaoxin Sheng
Anonymous
6 years agoNot applicable
Thank you for your help, it's helped a lot.
My records are still summarizing. I'm not sure what you meant with adding more row categories and drill them to split summarize?