Tree visualisation showing info about sub-categories

Hi Anonymous 

 

Based on your screenshot, it looks like you want to create a matrix visualization in Power BI that displays item category and subcategory information.

 

You can try the following:

 

Add the Decomposition Tree Visual to Your Report:

 

In your Power BI report, select the Decomposition Tree icon from the Visualizations pane to add it to your report canvas.

 

Configure the Visual:

 

Drag the field representing your main category to the Analyze bucket.

 

Then, drag the fields representing sub-categories or other related information into the Explain by bucket. This setup allows you to drill down into your categories and explore sub-categories in detail.

Once your visual is set up, you can start exploring your data by clicking on a category and then drilling down into its sub-categories.

The Decomposition Tree also supports AI-powered suggestions for the next dimension to drill into, which can be particularly useful for ad hoc data exploration.

 

You can view the link below for more details:

 

Decomposition tree - Power BI | Microsoft Learn

 

Regards,

Nono Chen

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