Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous,

Matrix is used to group and aggregate records based on row/column categories. It does not support to use as table visual to display "not summarize" records.

For your requirement, I'd like to suggest you use table visuals or add more categories to matrix visual category to expand summarize records.(e.g. index)

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you. 

 

The data I have looks this: 

 I would like for it go look like this: 

 

What would be the best way to go?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago
      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?