Manually set column pixel width in Power DI Desktop

[Emile_Diedrick]

 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.

[Jaywant-Thorat · Accepted solution]

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