desktop
7 TopicsDefault Grow To Fit, Auto-Size Width - October 2025 Release
To PBI developers and fellow users, The new October update bringing Grow to fit as a default has been frustrating to work with. As someone who has used Power BI for the better part of a decade I find it much cleaner and user friendly to manage my column widths instead of arbitrarily assigning widths based on the space of a block. This is how we all have been doing for years. Per the release notes: https://powerbi.microsoft.com/en-us/blog/power-bi-october-2025-feature-summary/ Auto expand table columns The Grow to fit option distributes extra space across columns for cleaner visuals. And I'm not the only one: As Kyle puts it, we are frustrated by being forced default options that, in our opinion, degrade user experience. I encourage making the service easier for new users to drop in things and make it look pretty with minimal effort. But now I have to go into each table and switch this setting each time I want to return to a traditionally auto-sized column. Please make the default "Fit to Content". Or at least give an option to set a client preference for one or the other. Thank you, generatorsam7KViews17likes11CommentsHow to filter sum function within Tablix using value within row
Im having trouble with power BI Report Builder for somthing that feels like it could be pretty simple but isnt and it may be because i dont understand how to refrence values that are in diffrent scopes. Basically i have 2 tables, one is a table that just has jobs listed on it(So like Project Manager, Anylist, that kind of thing) and another that lists hours worked each week by diffrent people, and it includes a column that refrences what position they are, so it would be a one to many relationship between Job DataSet and Worked DataSet on their column. I have a tablix that is using the Jobs DataSet and what i want to do is have a column that sums up all of the hours worked, but filter it so that it only sums up the ones who their Job column is equal to the Job value of the row on the table, but i just cant get it to work. I can get it to only sum up ones whos Job column matches a static string, and a perameter, but i just cant for the life of me get it to use values within the row itself. Anyone have any help? Thanks!Solved395Views0likes1CommentDate Slicer - calendar icon size is not increasing according to values size (using between type)
I have a Date Slicer (using between type) when i increase values font size the calender icon size is not increasing it remains same. Values (font size: 32) Values (font size: 9):Solved973Views0likes3CommentsMatrix table: how the columns dynamically live in the middle of the visual objects
At the top of the figure is the matrix table, at the bottom is the bar chart, and on the right is the filter. No matter how many options (one or more) the filter chooses, the bar chart can be in the middle of the visual object. How can the matrix table also achieve this effect?(Note:The matrix table is automatically aligned from the left,I want to be in the middle of visual objects no matter how many columns.)442Views0likes2CommentsServer dails to refresh "Qe cannot convert the value "[Binary]" to type Binary" No binary value
I am getting to types of errors which are probably related. For context, the dashboard is a large and complex model with over 20 queries and 15 data sources, pulling from Azure, Shaerpoint and other sources. First, on the desktop, I can only refresh the data when I open the Power Query editor, refresh the data sources and then close it. Then I can refesh the data with no problems. Otherwise, one of the query dependencies will fail. Second, once I do the Power Query editor part and I upload, I always get this error but in different queries: Data source error: Expression.Error: We cannot convert the value "[Binary]" to type Binary.. . The exception was raised by the IDbCommand interface. Table: XXXXX. The Table will change on each iteration. None of the tables have binary values.Solved778Views0likes2CommentsHow to make data that are unavailable in my dataset to show % automatically when data is present
Hello, i need some advice on how to handle the visual automatically when data is available. Problem now is some data is not available yet in my dataset. Currently, my dataset does not have Severity = S2 data. Only have S3 and S4 data. I manually hardcoded it to show N/A for S2. See snippet (A). How can i handle this automatically when data is available instead of hardcoding? (A) I don't know why when i applied the same measure for S3 and S4 on S2 Tile, it shows 100% eventho' there's no S2 data present. See snippet (B) (B) Please help. Thanks594Views0likes1CommentText formatting can't be customized in custom or built-in themes
Hello, Microsoft introduced a new feature "export current theme". In this, when we go to Home > switch theme > customize current theme > Text In General, we get warning message " Text formatting can't be customized in custom or built-in themes that were added to reports before September 2019. " I need to understand what is the warning for and with this font family, size all are disabled for Text.1.4KViews0likes3Comments