Fix first three columns in a table

Power BI
1

I have a table visual and what I want is when the users scroll right for the first three columns in the table to remain fixed and visible. Currently they just scroll away.

If you think ogf Excel I just want to Freeze panes.
I can put it into a Matrix but that changes the presentation - I now get three rows one for each row that was in the table.

Hope I am not missing something obvious
Thanks
E

2

Hi @ells,

Thank you for your post.

Currently it is not possible in Power BI native table visual ( Microsoft Idea posted at 2015:
https://ideas.powerbi.com/ideas/idea/?ideaid=7122fbe0-a329-4af8-9af8-dbd0f2a3413e

) .

2 things you can do:

  • matrix (as you describe - If you need further assistance with matrix formatting provide a sample PBIX with some sample data so members can assist you with that)

  • workaround (it depends of number of rows, no sure if this will be suitable for your case )

With this workaround you need to copy -paste tables ( + keep same sort , format a little bit) and get something like this:

image
image1459×445 73 KB

Main drawback of this is if you have lots of rows and you need to scroll down - so this will happened:

image
image1452×362 51.8 KB

You can have just freeze panes dimensions in one and rest in others if you needed (I can explain little bit further that approach if needed).

Maybe someone has another idea as well.

3

Hi @ells. While I don’t have direct experience with it, I hear the InfoRiver custom visual provides an Excel-like interface … perhaps that could help? Greg

1 Like
4

Thanks all,
I am stuck with native Power BI visuals so at least I know the current aproach is as good as it it going to be.

There are a substantial number of rows so a table split would not work.

Thanks
E

5

Hi @ells,
I don’t know if you have been able to try the following trick in a Power BI matrix:

Solved: Re: Freeze first column in table - Microsoft Power BI Community

I also tried to make the matrix with the first 3 columns fixed in HTML using the HTML Content, but I see that it takes a lot longer to load and the scroll bar doesn’t go quite right.
For the latter I followed the following video:

Regards,

UBG to DAX - Data Model.xlsx (677.6 KB)
Fix3FistColumntable_JAFP.pbix (1.2 MB)

6

Hi @ells did the response provided by the community members and experts help in solving your query?

If not, how far did you get, and what kind of help do you need further?

If yes, kindly mark the answer that solved your query as the SOLUTION. Thanks!

7

Hi @ells , we noticed that no response was received from you with regard to our post last Nov 27th.

We just want to check if you still need further help with this post.

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

8

Hello @ells , Due to the length by which this post has been active, we are tagging it as Solved. Thanks to the contributors of this post. For further questions related to this post, please make a new thread. Feel free to reopen this thread if you anyone would like to answer the pending inquiry above.