Make table column width not adjustable for user / header as slicer

[bnjmnnl]

Hello all!

For a better user experience I want to transform the normal table-visual to a well known filterable table. To achieve this, I want to arrange a drop down filter for two fixed columns in a table, exactly as known in Excel or Power BI table view:

By clicking the down-arrow a dropdown pane will open to select the needed criteria for this table. My idea was to overlay a drop-down slicer on the column-header in the table-visual, however the user is able to adjust the width of the columns, and I cannot find a way to have this unavailable. Does anyone know a way to remove this obstacle? Maybe a workaround (like overlaying a transparant shape above to not be able to select the width button)? Or even a built-in function to have this available in the table-visual?

If more info is needed, please let me know!

Kind regards

[danextian · Accepted solution]

Hi @bnjmnnl 

Place a transparent shape over the table visual, ensuring it fully covers the column headers. Group the shape with the table, and make sure "Maintain layer order" is enabled for both visuals—this setting should be somewhere under the General section.
Note: This method will prevent users from resizing column widths, but it will also disable the ability to click on headers to sort the data.

[danextian · Accepted solution]

Hi @bnjmnnl 

Place a transparent shape over the table visual, ensuring it fully covers the column headers. Group the shape with the table, and make sure "Maintain layer order" is enabled for both visuals—this setting should be somewhere under the General section.
Note: This method will prevent users from resizing column widths, but it will also disable the ability to click on headers to sort the data.

[bnjmnnl · Accepted solution]

Thank you!

I will add transparent shapes above the little lines to adjust the width only. Then users will be able to sort the columns. Didn't know about the maintain layer function, so thank you for that!