Forum Discussion

Rodi123's avatar
Rodi123
Helper I
1 year ago
Solved

Responsive button for Matrix diagrams

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 wa...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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 Systems

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's avatar
Rodi123
Helper I
1 year ago

And how about the table?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.