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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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