Forum Discussion
Missing Columns in Matrix
Hello experts,
I have a matrix that should show the amounts invoiced to other subsidiary companies, but I am noticing that when there are many columns the matrix reaches a column limit(it ssems to be 20 columns)
For example, in this case it does not show the last 8 columns. Is there a limit to the number of columns to display in a matrix?.
It is showing only 20 columns. Is there a way to fix this?
The limit is 100 columns. Even that is way too much. Horizontal scrolling makes for a VERY BAD user experience. Avoid at all cost.
2 Replies
The limit is 100 columns. Even that is way too much. Horizontal scrolling makes for a VERY BAD user experience. Avoid at all cost.
Thanks for the reply from lbendlin , please allow me to provide another insight:
Hi, gomezc73
As lbendlin mentioned, this is indeed a limitation. Below is a screenshot of the relevant response:
For more details, please refer to:
Solved: Re: Limit on the number of columns in Table and Ma... - Microsoft Fabric Community
Solved: Too many values. Not showing all data in Matrix - Microsoft Fabric CommunityI also conducted a sample test by inserting an index column:
Its maximum value is 100.
Therefore, my alternative suggestion is: you can visualise the data by segmenting it into different objects:
1.Firstly, insert an index column:
2.Secondly, use the following measures as filters:
Measure = IF(MAX('financials'[Index])>=100,1,0)3.Here's my final result, which I hope meets your requirements.
4.Finally, if you feel that performance needs improvement, you can submit an idea and wait for users with similar needs to vote for it, helping you achieve this idea more quickly. Many features of our existing products are designed and upgraded based on customer feedback. As demand increases, this issue may be addressed in the future.
Here is the link to submit your idea:
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
