Power BI Report Builder - Repeat Parent Row Group Value

[101Mathew]

Hi All,

Unsure if this is the correct location (Please advise if I'm incorrect) - The report builder default is to only show the parent for a Row Group once, for each child value.

I would like to get the parent value to repeat for each row it's relevant - I've looked on line, I've tried Co-Pilot the suggestions are either wrong, or not present at all.

Please can you assist - also is there a good training material that covers these elements clearly?

Regards,

Mathew

[Anonymous]

Hi @101Mathew,

Thank you for reaching out in Microsoft Community Forum.

Thank you @BhavinVyas3003  for the helpful response.

Please follow below steps to Repeat Parent Value in Each Row in Report Builder;

1.Select the parent group cell in the Tablix where the value appears.

2.Go to the Properties pane and set HideDuplicates to None.

3.Or: Right-click → Text Box Properties → uncheck “Hide duplicates”. and This will Make sure the parent value repeats on every row instead of showing only once.

Please continue using Microsoft Community Forum.

If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,
Pavan.

[101Mathew]

Firstly thank you for your reply:

I presume you are talking about selecting this cell (see the Fig1a), this give me the properties in Fig1b?

I also tried selecting the Row Group version of Source System Fig2a, this gives me these options Fig2b

If I try selecting text box properties get this menu fig3a - I presume I'm missing something from your comments

In the final screen shot you'll see that the source system is not being repeated for each row of data it is connected too (fig 4)

Fig1a

Fig1b

2a clicking the Row Groups value

Fig2b

Fig3a

Fig 3a

Fig 4

[v-hjannapu · Accepted solution]

Hi @101Mathew,
Thank you for reaching out in Microsoft Community Forum.

In Design View, click the cell containing =Fields!Source_System.Value as shown in Fig1a.
 With that cell selected:
  Either use the Properties pane (Fig1b) and set:
  HideDuplicates = None
Or right-click on the cell → choose Text Box Properties → go to Visibility →
Uncheck: “Hide duplicates” (see Fig3a).
This tells Report Builder to show the value on every row, even if it's repeated.
Run the report again – your Fig4 should now display the parent value (Source System) on every row it relates to.

If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Best Regards,
Harshitha.
Community Support Team

[v-hjannapu]

Hi @101Mathew ,

Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank You.

Harshitha.

Community Support Team.

[v-hjannapu]

Hi @101Mathew  ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Thank You.

Harshitha.

Community Support Team.

[v-hjannapu]

Hi @101Mathew ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you,
Harshitha.

[BhavinVyas3003]

Hi,

Please see if this helps,

https://medium.com/bi3-technologies/repeating-tablix-row-group-value-on-each-row-in-power-bi-report-...

Thanks,

Bhavin

[101Mathew]

I tried that it does not seem to work