Hidden a column by setting width to 0 Cause horizontal Scrollbar and Truncated Text

[Zhinee]

I’m running into a limitation in Power BI and was wondering if anyone has found a better workaround.

Power BI doesn’t seem to support hiding a column directly in a table visual. As a workaround, I’ve set the column width to 0 and turned off text wrapping to avoid excessive row height.

However, this causes a couple of issues:

• A horizontal scroll bar appears in the table, and users have to scroll to the right.

• some values from the columns gets truncated, and for some reason, hovering doesn’t always show the full content in some rows. The values will sometimes end with ... I’m not sure why this happens.

Has anyone encountered this? Are there cleaner ways to hide a column without casuing UI issues like this? Or a way to ensure the full text appears?

Thanks in advance!

[mark_endicott]

@Zhinee - are you sorting Text values? 

If so, you'd be better off adding a column to your orginal data table that does this, and then using the "Sort By" function on the table settings:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column 

Then there's no need to add an additional column to a table that's not needed. 

[Zhinee]

So my table visual is a session table with a Session ID column (numeric).
If I want to sort by Session ID, I need to add it to the visual in order to perform the sort, right?
However, I want the sorting to happen without displaying the column to the user.

[mark_endicott · Accepted solution]

@Zhinee - So in that case it's your only option, but put it as the first column and turn off text wrapping, then minimize. 

I think this will prevent the horizontal scroll. 

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!

[mark_endicott]

@Zhinee - Dont include the column in the table if you're hiding it from view!

[Zhinee]

I am actually doing a sorting based on that column, but I am just hiding it.