Forum Discussion
Helper IIILayout issue in Power Bi paginated report
I wanted to create the report like below
but its not getting created as above its getting created as below where the values not ciming under the position value.
how i can achieve the same using power bi report builder when i tried using list its not creating and working as group like below
Thanks
Hi Aartibhilare
As I have reproduced the scenario with sample data, I got the solution that you are expecting.
You can follow the steps below to resolve the issue:
- Create the list and add data set and insert a List from the Insert tab and drag it onto the report area.
- Then add columns as per the requirement after that select data in list which will be shown inside the column like Start Time, End Time, Employee Name etc..
- Now click on top of the column then add a parent group in row group.
- Select the field which you want to add as a parent group and click on the add group header and then OK.
- It will be created as below after that click on the column which was created as a parent group and delete the column.
6. After the deleting the column the visual will appear as below.
7. Now click on the column above the Employee ID then select the field which you want to make as header (in my scenario I have taken position as header).
8. Adjust field sizes and alignments as needed and you will get the expected result as below.
By following these steps, you can achieve the desired layout in your Power BI paginated report. If you’re still facing specific issues, please let me know.
If this post was helpful, please consider marking Accept as a solution to assist other members in finding it more easily.
4 Replies
v-karpurapudCommunity Support
Hi Aartibhilare
Thanks for reaching out to the Microsoft Fabric Community Forum
As you are encountering an issue with the layout in the paginated report. Here are the steps to resolve the issue.
- Create the list and add data set and insert a List from the Insert tab and drag it onto the design surface and ensure your List is bound to the correct dataset. You can do this by right-clicking on the List, selecting Dataset Properties, and choosing the appropriate dataset.
- Next group the data by position and then make it as group header.
Right-click on the List control → Choose Add Group → Parent Group after in the Group By field,
select the Position column or field then check the Add Group Header box to create a header for each group.
- Inside the group header add a text box and set its value to =Fields!Position.Value (the Position field) and inside the group body add the fields which you want to display in the report.
- Click Run to preview the report and Verify that Each Position acts as a header Fields like Employee Name and Department are aligned correctly underneath. Adjust field sizes and alignments as needed.
By following these steps, you can achieve the desired layout in your Power BI paginated report. If you’re still facing specific issues, please let me know.
If this post was helpful, please consider marking Accept as a solution to assist other members in finding it more easily.
AartibhilareHi v-karpurapud
when i did till second step but its creating like this and i cant add text box under the Position Name
I believe is header just add the header where i can add other values but i cant just darg things like list and then group by
- v-karpurapud
Hi Aartibhilare
As I have reproduced the scenario with sample data, I got the solution that you are expecting.
You can follow the steps below to resolve the issue:
- Create the list and add data set and insert a List from the Insert tab and drag it onto the report area.
- Then add columns as per the requirement after that select data in list which will be shown inside the column like Start Time, End Time, Employee Name etc..
- Now click on top of the column then add a parent group in row group.
- Select the field which you want to add as a parent group and click on the add group header and then OK.
- It will be created as below after that click on the column which was created as a parent group and delete the column.
6. After the deleting the column the visual will appear as below.
7. Now click on the column above the Employee ID then select the field which you want to make as header (in my scenario I have taken position as header).
8. Adjust field sizes and alignments as needed and you will get the expected result as below.
By following these steps, you can achieve the desired layout in your Power BI paginated report. If you’re still facing specific issues, please let me know.
If this post was helpful, please consider marking Accept as a solution to assist other members in finding it more easily.
- Aartibhilare
Thanks v-karpurapud its just worked so good thank you so much