Power BI embedded analytics - SaaS application - fix column width of a matrix

[snph1777]

Hello folks,

The question I have is somewhat pedestrian in a regular Power BI Desktop.

However, I am working in a SaaS application that has an embedded Power BI component (Power BI embedded analytics).

This connects to a Microsoft Azure SQL Server database. I can always use just one single dataset, without calculated columns or measures; I cannot use DAX language either. I do not have Format option for my columns.

The dataset is essentially like a large table (or rather a view), developed using T-SQL language; it is called 'Report Columns'.

I now develop a simple matrix (sort of an Excel Pivot table) visual on my dataset in this embedded Power BI.

It is just a weekly time table report, where each of the 7 days in a given week, read employees schedule and job titles.

The dates are in columns, and the employee names in rows (the employee names are on the left side running vertically, but not shown in the the image file below).

The matrix changes its column width after each time I run the report.

I tried to use wrap text option, and disable Auto-Size.

Even after trying many solutions posted generally, I am not able to fix the column width of my matrix.

Any idea ?

Text wrapping of the Values part of my matrix is mandatory for my solution.

[Anonymous]

Hi @snph1777 ,

During my investigation I have found users in the past who have had similar experiences to you.

For original post, you may refer to:Solved: Re: Is There any way to fix Column Widths in a Mat... - Page 3 - Microsoft Fabric Community

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[snph1777]

I thoroughly reviewed the solution provided, it does NOT work for me; the Values in my matrix are long text data with job and schedule information; I need them (the text) wrapped, and then have a fixed column width in my matrix; the column name lengths of my matrix are not as issue, they already have the same length (width), say, 4-Wed,Feb 21, '24, which corresponds to Week Day # 4, Wednesday, Feb 21, 2024 (this length of 16 characters obviously will not change for any date). I even tried the equivalent of the REPT DAX function method (shown in the tutorials) in my T-SQL dataset; but to no avail.