Issue regarding freezing the column in Matrix table

[akshay_d29]

I have a scenerio where i want to create a Matrix table, which will freeze my first column while scrolling it horizontally, similar like excel.
but i am facing one issue here, i have kept my first column which (Engagement), in row section and other columns in value section. it is freezing the engagement column while scrolling, but the text columns which i have kept in values section are getting filtered as (show first) because of which it is not showing proper data.

is there any other way to do so?

[bhanu_gautam]

@akshay_d29 , You can try using a measure

Power BI requires an aggregation function for values in the Values section. For text columns, you can use the "First" or "Last" aggregation, but this might not always display the data as expected. Instead, consider using measures to concatenate text values if needed.

ConcatenatedText = CONCATENATEX(TableName, TableName[TextColumn], ", ")