Skip to main content
cancel
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

Reply
sman
Frequent Visitor

Linking decomposition tree to bar chart's x-axis

Hi!

 

I'm fairly new to PowerBI so please bear with me.

 

I have one table with sales for of various products. On each line there the sales amount, category level 1 and category level 2. I've created a decomposition tree showing the sales of various category combinations and a bar-chart showing the sales for each category level 2.

 

Now for my question; I want to add the functionality so that when I click a "category level 1" value in my decomposition tree, only the category level 2 values in that category are shown in my bar chart.

 

For example:

 

sman_0-1662648583263.png

Note that in the figure above, I want the "Carrot", "Cucumber" and "Potato" bars to be hidden when I've clicked "Fruit" in the decomposition tree

 

1 ACCEPTED SOLUTION
johncolley
Solution Sage
Solution Sage

Hi @sman , Easy solution to this! You need to use the Edit Iteractions feature to change the way the Decomposition Tree interacts with the Bar Chart. Currently it is cross highlighting you want it to Filter. To change this do the following:

1. Select the Decomposition Tree

2. Under Format select Edit Iteractions

johncolley_0-1662683183455.png

 

3. Change the option highlighted on bar chart to Filter

johncolley_1-1662683228504.png

 

4. It should filter out the other options.

johncolley_2-1662683256646.png

 

If this answer solves your problem please mark it as a solution!

View solution in original post

2 REPLIES 2
johncolley
Solution Sage
Solution Sage

Hi @sman , Easy solution to this! You need to use the Edit Iteractions feature to change the way the Decomposition Tree interacts with the Bar Chart. Currently it is cross highlighting you want it to Filter. To change this do the following:

1. Select the Decomposition Tree

2. Under Format select Edit Iteractions

johncolley_0-1662683183455.png

 

3. Change the option highlighted on bar chart to Filter

johncolley_1-1662683228504.png

 

4. It should filter out the other options.

johncolley_2-1662683256646.png

 

If this answer solves your problem please mark it as a solution!

Amazing - thank you!

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors