Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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.
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.
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.
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.
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.
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.
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |