Is it possible to freeze the two first column into a large table

[rojabi]

Imagine that I have a table  with many fields (ex: 20 variables) and that the two first columns are ItemID and Description.  I wonder if there is a way to freeze the two first columns into the table, so when you move the cursor to see the last fields, you still see the two first columns, so you are able to associate the content of the last column with a ItemID and Description.

Note: Not able to convert the visual to matrix from table because all fields are text fields.

It is possible to do that in Power BI?

Thanks in advance for your Help

[rojabi]

Imagine that I have a table  with many fields (ex: 20 variables) and that the two first columns are ItemID and Description.  I wonder if there is a way to freeze the two first columns into the table, so when you move the cursor to see the last fields, you still see the two first columns, so you are able to associate the content of the last column with a ItemID and Description.

Note: I can't convert the visual to matrix from table because of the data. I should freeze the columns only on table visual.

It is possible to do that in Power BI?

Thanks in advance for your Help

[amitchandak]

@rojabi , No, I doubt you can not do that in table visual

[parry2k · Accepted solution]

@rojabi well then you can concatenate those so that it list as one value, I'm just trying to give you an alternate based on what the current visuals are capable of.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[parry2k]

@rojabi although these are text columns, you can use max or min on the text column to show in the matrix visual

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[rojabi]

There are some fields with different values, If I use the min/max data won't be correct.

I need to freeze the columns in the table visual only the table visual not the matrix.

Thanks !

[parry2k]

@rojabi unfortunately not 😞

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.