Labels cannot be fully displayed on the treemap after being generated using Power BI Report Builder
Hi Team,
I created a treemap via Power BI report builder and setting revelant labels, but some labels can not be fully displayed if the text is too long. Is there any path I can set different Font Size for different length of labels and show "..." when the label too long.
Do you have any suggestion? Thank you in advance for your kindly help.
Thanks,
May
3 Comments
- AnonymousNot applicable
Hi,mshao .I am glad to help you.
You can try to write a custom function to control the size of the treemap font based on the value, or standardize it to a smaller font.
For more information about custom functions, you can refer to the following issueSolved: Row Banding in Paginated Report with Row Groups - Microsoft Fabric Community
Create a Treemap Graph in SSRS 2016 - MSSQLTips.com
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian - mshao
Helper III
Hi Carson,
Thank you so much for your reply.
We don't want to show size data and only want to show the series name. Do you have any more ideas?
- AnonymousNot applicable
Hi,mshao .Thank you for your reply.
I think another way would be to create custom functions in the paginated reports.
And use your custom function in the font settings in the treemap, or set smaller fonts.
URL:
Custom code and assembly references in expressions in a paginated report in Report Designer - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn