Forum Discussion

Emile_Diedrick's avatar
Emile_Diedrick
Regular Visitor
6 months ago
Solved

Manually set column pixel width in Power DI Desktop

 It will be great to set the column width of a matrix visual by entering a pixel value. For years this issue has been overlooked. Business users that are used to consuming Excel reports will prefer staying with Excel in the end.

Need Help
  • Jaywant-Thorat's avatar
    Jaywant-Thorat
    6 months ago

    Hi Emile_Diedrick 

    You cannot manually set column width in pixels in Power BI >> Table/Matrix Visual. This is a known, long-standing product limitation.

    There is:

    • No pixel input box
    • No setting in Format pane
    • No DAX workaround
    • No hidden JSON / theme trick

    Column width can only be changed by dragging with the mouse. 

    Power BI visuals are responsive web visuals, not Excel-style grid controls.
    Microsoft has repeatedly stated that exact pixel control is not currently supported for native tables/matrices.

    This has been a top-requested feature for years.

    There are few workarounds like:
    1. Turn off Auto-size

    2. Use padding tricks (partial)

    3. Paginated Reports (Excel-like control)

    4. Custom visuals (if allowed)

     

    Power BI tables are not designed to replace Excel for pixel-perfect layouts.

    Microsoft’s direction is:

    • Power BI → interactive analytics

    • Excel / Paginated → formatted reporting

    =================================================================
    Did I answer your question? Mark my post as a solution! This will help others on the forum!

    Appreciate your Kudos!!

    Jaywant Thorat | MCT | Data Analytics Coach | Super User
    LinkedIn: https://www.linkedin.com/in/jaywantthorat/
    Join #MissionPowerBIBharat: https://tinyurl.com/JoinMissionPowerBIBharat
    #MissionPowerBIBharat
    LIVE with Jaywant Thorat

1 Reply

  • Jaywant-Thorat's avatar
    Jaywant-Thorat
    Super User
    6 months ago

    Hi Emile_Diedrick 

    You cannot manually set column width in pixels in Power BI >> Table/Matrix Visual. This is a known, long-standing product limitation.

    There is:

    • No pixel input box
    • No setting in Format pane
    • No DAX workaround
    • No hidden JSON / theme trick

    Column width can only be changed by dragging with the mouse. 

    Power BI visuals are responsive web visuals, not Excel-style grid controls.
    Microsoft has repeatedly stated that exact pixel control is not currently supported for native tables/matrices.

    This has been a top-requested feature for years.

    There are few workarounds like:
    1. Turn off Auto-size

    2. Use padding tricks (partial)

    3. Paginated Reports (Excel-like control)

    4. Custom visuals (if allowed)

     

    Power BI tables are not designed to replace Excel for pixel-perfect layouts.

    Microsoft’s direction is:

    • Power BI → interactive analytics

    • Excel / Paginated → formatted reporting

    =================================================================
    Did I answer your question? Mark my post as a solution! This will help others on the forum!

    Appreciate your Kudos!!

    Jaywant Thorat | MCT | Data Analytics Coach | Super User
    LinkedIn: https://www.linkedin.com/in/jaywantthorat/
    Join #MissionPowerBIBharat: https://tinyurl.com/JoinMissionPowerBIBharat
    #MissionPowerBIBharat
    LIVE with Jaywant Thorat