Forum Discussion
Power BI Matrix Visual - increase the allowable columns from around 100 to at least 140
The matrix visual is currently set to around 100 columns. I have a report of Air Quality permit numbers that ranges up to almost 140.
The matrix will not show all of the columns, so the customer has to filter the list with slicers the get the display to below 100 columns.
This report has been un use for several years, and I would like to see it work correctly.
Thank you,
Johnny Jones
7 Replies
Anonymous
This sort of thing, suggestions for improving the tool, would go in the Fabric ideas forum here:
https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas
For your report, could you move the permit numbers to the rows instead of the columns which would allow you to display all the records?
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.
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.
Hi Anonymous ,
we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,Chaithanya.
Hi @redcof ,
we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,Chaithanya.
Hi @redcof ,
we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,Chaithanya.
