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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
EdFord77
New Member

Unexpected interaction behaviours using stacked bars & columns - PBI Desktop visuals

hello,

 

I'm having a strange issue with the interactions between a stacked column & line visual and a stacked bar chart, it's a bit hard to explain so hopefully this is clear...

 

The 2 visuals look like this, the top has sales by month, the bottom visual has sales by client

 

EdFord77_0-1713436361250.png

If I click on one of the client bars in the bottom visuals I expect to see the cross filtering as per the below screenshots, with the columns still visable but ghosted out and only the selected section highlighted

EdFord77_1-1713436517319.png

EdFord77_3-1713436891295.png

However, the unexpected behaviour occurs only when I select the green part of client 1 or 3, it does not affect any other colour or client - see below

EdFord77_2-1713436612419.png

when the green part of client 1 or 3 is selected in the bottom visual, the top visual only shows the highlighted part and nothing else and I can't for the life of me figure out why. I have tried deleting and rebuilding the visuals from scratch but still have the same issue.

 

Has anyone else experienced this or have any idea why it might be occuring? 

 

Thanks!

 

 

 

 

1 ACCEPTED SOLUTION
v-jiewu-msft
Community Support
Community Support

Hi @EdFord77 ,

Based on my testing, please try the following methods:

1.Create the simple table.

vjiewumsft_0-1713499352172.png

2.Create the column chart visual and drag the field into the values.

vjiewumsft_1-1713499368690.png

vjiewumsft_2-1713499374970.png

3.Create the bar chart visual and drag the field into the values.

vjiewumsft_3-1713499390645.png

4.Click on the client bars visual and the column chart shows selected section. The result is shown below.

vjiewumsft_4-1713499400267.png

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format to make a deep troubleshooting? It would be helpful to find out the solution.

How to provide sample data in the Power BI Forum

 

Best Regards,

Wisdom wUW

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

 

View solution in original post

1 REPLY 1
v-jiewu-msft
Community Support
Community Support

Hi @EdFord77 ,

Based on my testing, please try the following methods:

1.Create the simple table.

vjiewumsft_0-1713499352172.png

2.Create the column chart visual and drag the field into the values.

vjiewumsft_1-1713499368690.png

vjiewumsft_2-1713499374970.png

3.Create the bar chart visual and drag the field into the values.

vjiewumsft_3-1713499390645.png

4.Click on the client bars visual and the column chart shows selected section. The result is shown below.

vjiewumsft_4-1713499400267.png

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format to make a deep troubleshooting? It would be helpful to find out the solution.

How to provide sample data in the Power BI Forum

 

Best Regards,

Wisdom wUW

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

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.