Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
1 year ago
Solved

Show only selected subcategories labels

i want to display subcategories labels for only selected category in tree map in Power BI  , example if i click on box of "Technoogy" category (in red color) then subcategories labels of technology category should appear and other subcategory lables should not appear as shown below 

 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from lbendlin, please allow me to provide another insight.
    Hi powerbiexpert22 ,

    I am not sure how your data model is designed, here is my sample.

     

    The data table is as follows.

     

    Each Treemap visual adds the Category field as a visual level filter, with the settings being a category of the Category field, but different from each other.

     

    The result after selecting the Technoogy category is as follows. Hopefully it will meet your needs.


    Please see the attached pbix for reference.
    Best Regards,
    Dengliang Li

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for the reply from lbendlin, please allow me to provide another insight.
    Hi powerbiexpert22 ,

    I am not sure how your data model is designed, here is my sample.

     

    The data table is as follows.

     

    Each Treemap visual adds the Category field as a visual level filter, with the settings being a category of the Category field, but different from each other.

     

    The result after selecting the Technoogy category is as follows. Hopefully it will meet your needs.


    Please see the attached pbix for reference.
    Best Regards,
    Dengliang Li

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