Forum Discussion
Power BI Matrix Visual - increase the allowable columns from around 100 to at least 140
Hi Anonymous ,
Actually below are the ways to show all the 140 columns
1) Use “Show on Rows” -> Go to Matrix visual settings → Values → Show on rows = ON.
This converts your wide column layout into a vertical format, displaying what were columns as individual rows.
You’ll keep all 140 permit numbers visible, with scrolling down instead of across.
2) Use a Table Visual Instead:
-> Try switching to a Table visual, which can sometimes render more columns than Matrix.
-> Table visuals support horizontal scrolling better.
3) Split the Data into Groups:
If the 140 columns are present split them into groups (e.g., 70+70) and create two separate visuals.
if the issue still persist I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels, such as the Microsoft Fabric Ideas.
Regards
Chaithanya.
That did not work for me. I need the update requested.
Thanks.
Hi Anonymous ,
Thank you for reaching out to Microsoft Fabric Community Forum.
I have done some workaround on this issue and found that the matrix doesn't support so many columns. It seems to support up to 100 columns. It won't show all these column values. As a workaround, you could consider insert a slicer to dynamically filter matrix columns.
https://community.powerbi.com/t5/Desktop/Too-many-values-Not-showing-all-data-in-Matrix/td-p/412759
Attaching few more links for your reference
Regards,
Chaithanya.