cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dbguy90
New Member

Issue with Stacked Bar Chart Visual Not Updating Slicers

Hi,

 

I'm pretty confused as to how I broke my report, but I'm sure it's a fairly easy fix?

On one side of the page I have a stacked bar chart, and on the other side I have a bunch of slicers. When selecting a value in the stacked bar chart, my report used to dynamically update those slicers. For example, if you selected the label "Pizza" in the stacked bar chart, the slicers would update to only show possible values from rows relating to "Pizza".

Now when I select a label in the stacked bar chart, the slicers do not update at all. However, if I select a value in a slicer, the visual updates as expected. (i.e. the linkage works in one direction but not the other)

Hopefully that makes sense. Any help would be greatly appreciated! I can't figure out what I changed.

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi dbguy90,

It seems that you want to use visual to control slicer, right? This couldn't be supported currently. You need to know that when you use slicer, it will affect the visual, this is a single direction interactions  and this is by design. When you click on visual , it will highlight corresponding field or value in other visuals instead of slicer, it can't affect slicer.

You could submit this requirement in power-bi-ideas .

Best Regards,
Zoe Zhi

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

6 REPLIES 6
dax
Community Support
Community Support

Hi dbguy90,

It seems that you want to use visual to control slicer, right? This couldn't be supported currently. You need to know that when you use slicer, it will affect the visual, this is a single direction interactions  and this is by design. When you click on visual , it will highlight corresponding field or value in other visuals instead of slicer, it can't affect slicer.

You could submit this requirement in power-bi-ideas .

Best Regards,
Zoe Zhi

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

Hi,

 

Correct. When highlighting a bar in my bar chart, I want the slicers to update. I could have sworn this was the behavior I had previously, but maybe I'm misremembering? It works on other visuals, just not this stacked bar chart.

Unfortunately I'm reluctant to post screen grabs due to the sensitivity of the data we're working with.

dax
Community Support
Community Support

Hi dbguy90,

As I know, when highlighting a bar in my bar chart, Slicer can't update, this is by design. You might be misremembering.

Best Regards,
Zoe Zhi

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

 

mwegener
Super User II
Super User II

Hi @dbguy90 ,

 

check this out.

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


Hi, thanks for the reply.

 

Editing the interactions does not seem to help. I'm at a loss as to what is going on.

Hi @dbguy90 ,

 

could you share some screenshots? (model and interaction)

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors