Forum Discussion

akshay_d29's avatar
akshay_d29
Regular Visitor
2 years ago

Issue regarding freezing the column in Matrix table

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?


Need Help

1 Reply

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    2 years ago

    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], ", ")