cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Ability to adjust column width inside table in Power BI Designer

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.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Ability to adjust column width inside table in Power BI Designer

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.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Helper II
Helper II

Re: Ability to adjust column width inside table in Power BI Designer

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors