Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
@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?
Proud to be a Super User!
hi,
There are about 176 columns
@saranee ok why would you want to see 176 columns on a page? what are you trying to do with that many columns
Proud to be a Super User!
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.
@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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |