Auto resize columns width based on no. of columns selected in matrix

[Saibal_78]

Hi All,

I am working on a report where I want auto adjust columns width in a matrix based on no. columns present in the matrix which is in turn coming from a date range slicer. This is similar feature which is there in clustered column chart, not sure the same can be replicated in matrix.

Below measure helps me create columns with identical width, but as soon as I add new date in the range it doesn't refresh which is obvious as auto-size width is turned off. 

Col_width =

Var selected_months = ALLSELECTED('Date'[Date])

Var selected_months_count = CONVERT(CALCULATE(DISTINCTCOUNT('Date'[Period]), 'Date'[Date] in selected_months),INTEGER)

Var chart_length = CONVERT(115,INTEGER)

RETURN

REPT("0",chart_length/selected_months_count)

This is what I get using this measure, which I dont want. I want to get the matrix table behave the way below clustered chart is behaving.

I uderstand the purpose of above measure is different, however want to know if this can be somehow achieved. Any suggestion will be highly appreciated.

Thanks

[rajendraongole1]

Hi @Saibal_78 - Unfortunately, the matrix visualization in Power BI doesn't currently support dynamic column width adjustments similar to the clustered column chart.

similar workaround we can do it by combination of calculated columns and conditional formatting to simulate dynamic column widths.

create a new calculated column :

Col_Width =
VAR Selected_Months = ALLSELECTED('Date'[Date])
VAR Selected_Months_Count = CALCULATE(DISTINCTCOUNT('Date'[Period]), 'Date'[Date] IN Selected_Months)
RETURN
Selected_Months_Count * 10 // Adjust the multiplier to control the width

use this calculated colum based conditional formatting and select the font size to influence the width of the column directly.

Try the above approach and let know.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Saibal_78]

Hi 

Thanke for the reply, not sure if I understood your last sentence, do you mean conditional formatting of the value field as shown in below screen shot? what exact steps should I follow?

Thanks