Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Alay
Helper I
Helper I

Ability to adjust column width inside table in Power BI Designer

Hello Colleagues,

 

Wanted to get some guidance on these two capabilities. They don't seem to be working in either the Online tool or the Desktop.

 

  • Can’t sort in a descending order on matrix or table
  • Can’t set fixed column width on columns on matrix or table

 

Thoughts / Guidance would be greatly appreciated!

 

Tks & Rgds,

 

Alay

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

For the first one, just click on the column that you want to sort by. If it sorts it the wrong way, click it again.

 

In the Desktop, you can drag the column separator to the desired width. Unfortunately, this generally gets horked up (technical term) when you upload it to the Service.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

For the first one, just click on the column that you want to sort by. If it sorts it the wrong way, click it again.

 

In the Desktop, you can drag the column separator to the desired width. Unfortunately, this generally gets horked up (technical term) when you upload it to the Service.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

I had the same question and was pleased to find this easy solution (to the second part). We'll see how horked up it gets when I publish. 😉

 

The column separator is difficult to see (and easy to miss) under the default table style. Luckily, I was playing with the various styles and happened to have it set to Bold header. The separator lines are much easier to see in this style.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.