Repeat and Scroll Headers for Table in Power BI Paginated Report

hi guys welcome back to the channel and let's continue with the power we presented report the series which you started yesterday the next uh scenario where client expect from you is that so with yesterday we created a very basic report right you run this report okay okay so there is two pages through to this report okay so we can navigate from here like page one and page two next you can go ahead and come back okay and even we can scroll it out the problem here what is happening is the heading The Heading of this right suppose you are moving it now I don't know which is ID with this name which is what and all not this heading so not report heading I'm talking about the table learning ID name department and salary right when I'm scrolling it I don't know which one is ID which one's name which is the salary and that's the problem on this one also on the next page right so that I want to repeat across when I'm navigating to the page on even I want to when I'm scrolling it I want my table header should be intact right so that's the requirement we want to read let's go to that so here one thing people first of all will run like that let's select this table okay let's select this table right click on this and there is a tablets so in power play Sorry positionated report right the normal table is called the tablets tablets is nothing but it's a combination of table list and Matrix okay so this makes a tablets okay so it's a normal but they they have Twitter is a tablets but here if you click on the tablets properties there is two options I repeat header rows on each page repeat header column on each page right so let's try to do that repeat header rows on PE space I want to do like that right my table headers would be repeat so let's select this okay and run it and just now move to the next page this will not work okay even if you're scrolling down also that repeat header will not work okay so this information which you've done it let's select it again sorry right click on this and your tablets property this is a very misleaded information actually this will never work this will work in a different way that we will subsequently will use that but for this to work or this solution is available on your group and even if we click on the properties okay and if you select this this one then you will get some properties here as well so here also you can choose the repeat additional all day so so that's repeat with everything we can do it's the same way you can just do it this way the capex properties with okay but I want to introduce to another one the I just don't want the properties here sorry I want the properties along with that I want to enable the grouping here okay so grouping here normally it is a normal grouping is available we'll come to the grouping later but just understand the grouping for the solution now normally there is a normal value is details if you select this it'll select only this part the member of this table okay we are not having any heading information on the group so it is just selecting the members which are available on the tablets or the table this is just a tablets member you see and if you normally select this this is the property of the text or because this is your selecting then there's a tablets property but when you select this the system number but we need the Addam as well so for that what we need to do here in this case is there is a drop down here on the group section click on that and click on the advanced mode okay once you click on the advanced move some static section will be available on the column groups and if you select it it will select each heading of this one by one so this is ID this is name this is Department this is salary but this is column but when you select the details it was there previously but when you select the starting it is selecting completely the header now and this is your member right and this is your member but this is a header now in this header two properties are there which you need to Make It Count so that your problem will be solved the first property is called repeat on new page okay I will create this repeat on new page that you need to make user J true okay so if you've done that once you that done that let's run it repeat on the new page right so now next navigate to the next page so there's the ID name Department salary let's go to next page see this header is repeated on the next page as well the ID name department and salary it is not going anywhere okay but this is the way but when you scroll again this will not work okay so for the scroll we need to again select your the static property which is the normal header then we need to select one more property which is called the fixed data okay fix data if you select it then your both the problems will be solved okay now run it now the subject okay so the ID name Department cell this is the heading of the triple if you go to the next page it is there okay come back to step now if you scroll see my data is scrolling but my things are things are there see ID name Department service everything is there wherever you scroll your heading will be always present nothing will be there so which properties the two things first of all we need to click on the advanced mode of the group then select your row group as the header then fixed data is for the scrolling area and repeat on the new page when you move to the new page these two property you need to make it as a true so that your problem will be reserved okay so hope you like this video please do subscribe to the channel for more interesting content like this and have a nice day thank you

Channel: Simple Analytics

Views: 1,328

Keywords:

Id: mfgiO0fIn40

Length: 6min 51sec (411 seconds)

Published: Tue Apr 18 2023