Dynamic Subtotal label rename in Power BI Report Builder

[prakash11440278]

Hi All,

How to dynamically rename the subtotal labels in Power BI Report Builder? I am using Matrix chart. In below image i want to replace the "Order Total" text with dynamic values like S071950Total, S071951Total...etc

[v-rongtiep-msft · Accepted solution]

Hi @prakash11440278 ,

For standard report types, you can't rename field labels specifically for reports. Instead, you'd have to create a custom report type (Setup > Create > Report Types). You can rename the field entirely (including on page layouts and so on), using Setup > Customize > Tab Names and Labels > Rename Tabs and Labels. Rename Tabs and Labels does not cover labels that are automatically generated (such as Account/Lead Rating), which I believe are immutable.

Best Regards

Community Support Team _ polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[prakash11440278]

Hi @v-rongtiep-msft ,

Can you please explain in brief how to create a custom report type as mentioned below. 

"Instead, you'd have to create a custom report type (Setup > Create > Report Types). You can rename the field entirely (including on page layouts and so on), using Setup > Customize > Tab Names and Labels > Rename Tabs and Labels. "

[v-rongtiep-msft]

Hi, @prakash11440278 

Please refer to the following article to see if it helps you,

https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder

Best Regards

Community Support Team _ polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.