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
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
Fabcon_Europe_Social_Bogo

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.