matrix not showing more than specific number of columns in power bi

[saranee]

Hi all,

A little help from you are required for this issue:

all the columns in a matrix are not displaying with a message at extreme top left :

Too Many Values. Not Showing All Date. 

Any help is much appreciated

Attached image of message

[v-yulgu-msft]

Hi @saranee,

I can reproduce this scenario in my test. As we can see, the matrix doesn't support so many columns. It won't show all these column values. We are not able to change this limitation. As a workaround, please consider insert a slicer to dynamically filter matrix columns. Alternatively, you could pivot the ColumnA in query editor mode so that values a,b,c,d......will be converted into column headers. Then, use a table visual to hold data. But it's a awkward workaround as you need to drag 176 fields into table manually.

Regards,
Yuliana Gu

[vanessafvg]

@saranee how much  data is there?  power bi is not designed to show a huge amount of data because its a data visualisation tool.   try filtering?  what are you trying to do?

[saranee]

hi,

There are about 176 columns

[vanessafvg]

@saranee ok why would you want to see 176 columns on a page? what are you trying to do with that many columns

[saranee]

We are basically using value of a single column dynamically as column headers.

Say there is a column A with values a,b,c.column headers will be a,b,c.later values change to a,b,c.,d,e.Column headers will be a,b,c,d,e.

Basically it is a client requirement.

[vanessafvg]

@saranee is it possible to see the code?  i think the question is though why would you ever want to see 176 columns on a page, yes bring 176 columns into your model to derive certain information, but to bring all 176 into the visual layer probably doesn't make sense.   However i guess ther customer is always 'right', i can't find any documentation around the limit, but maybe you should see how your memory is faring when you try to pull all that data in.