Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
We've been working with Treemaps in Paginated Report Builder and encountered a challenge:
How can we remove the category field name that appears in the top left corner of the visualisation?
After a lot of trial and error, our team managed to hide it using the following expression in the Data Label Visibility property:
=IIf(Count(Fields!PSA_Assets_AssetName_.Value)>1,true,false)
Strangely, this only works with >1. If we try >0 or even >0.9, the label remains visible.
We consider this more of a workaround than a proper solution — especially since, when a manufacturer only has one asset, this method hides both the manufacturer name and the count, which is not ideal for reporting clarity.
Has anyone found a more robust or elegant solution to this issue?
Thanks in advance!
Martina Cahya Pratiwi
Business Intelligence Analyst
Solved! Go to Solution.
Hi @martinacahya,
Currently, there is no built-in property in SSRS or Paginated Report Builder that allows report authors to remove or suppress the category field name
You can submit a feature request via Ideas forum so that Microsoft may consider it in feature. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
https://ideas.fabric.microsoft.com/ideas/search-ideas
Regards,
Vinay Pabbu
Hi @martinacahya,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Vinay Pabbu
Hi Vinay,
Thank you for the follow-up.
I don’t think the suggestion fully addresses our issue, as it points to formatting in Power BI visuals, while our current requirement is specifically for Paginated Report Builder (SSRS). We're looking for a way to handle this directly within that environment.
Appreciate your support, and please let us know if there are any alternative approaches within SSRS.
Best regards,
Martina
Hi @martinacahya,
Currently, there is no built-in property in SSRS or Paginated Report Builder that allows report authors to remove or suppress the category field name
You can submit a feature request via Ideas forum so that Microsoft may consider it in feature. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
https://ideas.fabric.microsoft.com/ideas/search-ideas
Regards,
Vinay Pabbu
Hi Vinay,
Thank you for the clarification.
It's good to know that this behavior is currently a limitation within Paginated Report Builder. We've submitted a feature request via the Ideas forum as suggested, since having control over category field labels in Treemaps would greatly improve formatting flexibility for report authors.
Appreciate your time and support!
Best regards,
Martina Cahya Pratiwi
Business Intelligence Analyst
www.teamlogix.com.au
Hi @martinacahya,
Thank you for reaching out to Microsoft Fabric Community Forum.
There is no official, robust solution to fully and cleanly remove the category field name (group label) from a Treemap in Paginated Report Builder (SSRS).
Use Power BI visuals for more control where Treemaps offer full formatting control.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu