Forum Discussion

mafioso's avatar
mafioso
Icon for Helper II rankHelper II
8 years ago
Solved

Too many values. Not showing all data in Matrix

I'm currently facing a big problem. Not all my data gets displayed in the Matrix. I have to display it (customer requirement). There are after the drill down just around 200 cols and not all of them are displayed. I've read a lot of articles where other users have similar problems but nothing seemed to work. Here is what my table looks like:

 

 

The rows are my cost centers + work packages and the cols are the employees. Is it possible to show all of the employees? If I just put the employees in the rows section everything works, so why doesn't that work for the col section?

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support

    mafioso,

     

    It seems to support up to 100 columns. You may try adding a slicer or visual level filters.