Missing Columns in Matrix

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 Community

I 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:

Microsoft Idea

Microsoft 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.