Forum Discussion

martinacahya's avatar
martinacahya
Frequent Visitor
1 year ago
Solved

Paginated Report Builder Treemap Issues

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

www.teamlogix.com.au

  • Anonymous's avatar
    Anonymous
    1 year ago

    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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

    • martinacahya's avatar
      martinacahya
      Frequent Visitor

      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

      • Anonymous's avatar
        Anonymous
        Not applicable

        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