Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Display product groups and products in a tree view and filter a report based on a button click.

Hi all,


I need to develop a report which displays product groups and products in a tree view and then filters a report displaying data on the selected product. (Ideally the tree view would dynamically update to reflect changes in the product table but I can see no way to achieve that at the moment. The ability to use measures with buttons or text boxes would perhaps be a solution for the future but that's not an option at this time.)


I need to produce this report optimised for a large touch screen which is why I default to the idea of buttons as they can be made visually appealing and located as required to manually display the tree view on a couple of report pages.

(My report consumers don't want slicers, drop-downs, drill down etc. just a simple point and click experience.)

I'm only dealing with around 20 product groups and around 200 products so I was thinking of using bookmarks to navigate and display the product group tree and the chicklet slicer to display the products in each group. This is obviously not dynamic for the product groups but may be my best option at the moment.


Could anyone suggest a better way to do this?

I'm only a newbie at the moment so perhaps I have missed something or simply don't grasp an underlying principal.


Thanks for your consideration.


Super User
Super User

The matrix visual has the option to add a "+/-" box to indicate that levels can be expanded or collapsed. That box can be resized to make it more touch screen friendly. Maybe that's sufficient?

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.