Responsive button for Matrix diagrams

[Rodi123]

Hi there,

Does anyone know how to make a matrix diagram with one single button responsive to the width of a contrainer (Visual)?

I don't think the option is there, but maybe there is another way to do this.

Or if not, when is this coming?

[Anonymous]

Hi @Rodi123 ,

To make all the columns of the matrix equal in width, you can refer to the following steps.

Create a measure by entering a string value equal to the length of the longest column heading.And add it to the matrix.

measure = "1111111111111111"

Then go to Format Pane->Column Headers->Disable Auto-size width.

Remove this measure from the matrix so that each column of the matrix is now equal in width.

How to make your matrix column widths all equal to each other in Power BI using DAX. - Purple Frog S...

Power BI matrix column width sizing

However, this process must be performed manually.
If you want to create a button to perform a similar process responsively.

It is recommended that you submit this idea and add your comments there to improve Power BI and make this feature coming sooner.
Microsoft Fabric Ideas

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rodi123]

And how about the table?

[Anonymous · Accepted solution]

Hi @Rodi123 ,

Please refers to the following steps.

There are two visuals in the example, the table and the card.

Select the table, go to the Format pane, and turn off "Auto-size width".

Enable the "Power BI Project(.pbib) save option" in the "Options" menu.

Create a new folder and save the report as .pbip.
Go to the .pbip folder where these files are stored and open the .Report folder.

Open the "visuals" folder using VS CODE.

There are two entries in the left directory under visuals, corresponding to the two visual objects.
Checking the visual.json of the first item indicates that the item is a table visual.

You can do CTRL + F to find the 'columnWidth' property. The 'Value' attribute is the width of the column.

You can set all columns to the same width as the longest width column. Then, save the changes.

Then, open the PBIP file and view it in Powe BI Desktop. All columns in the table should now be the same width.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rodi123]

Now i had to manually drag column 'test12345' all the way to the end. So its kinda weird that there isn't a responsive button to do this. So a button that makes the diagram responsive but also make all the columns same width or something.

[ExcelMonke]

Hello,
Could you expand on what you mean by "One single button responsive to the width of a cont(r)ainer"?