Join Gini von Courter for an in-depth discussion in this video Set visualization interactions, part of Power BI Pro Essential Training.
- [Voiceover] By default the visualizations in this report affect each other. They're used to be able to cross filter information even if I am using, not a slicer, but the map to select Virginia, notice that it modifies what's happening in my column chart. That may or may not be what I want. It's possible that what I'd like to have is the ability to have these less connected.
To be able to have them not interact as strongly as they do. For example, it's possible on the district information page that I'd like to be able to have my users choose something and not have it affect everything else. And if that's what I want, what I need to do is essentially disconnect the interaction between two or more of these moving parts. So, let's return to our store info page and click edit report.
And what we want to do is click visual interactions and the button will then have a highlight behind it so we can tell it's turned on. And when I select a particular visualization the other visualizations light up. Let's say for example, that if someone modifies the map, we really don't want that to modify anything else or when someone chooses an item we wouldn't want it to modify anything.
Now, notice that it doesn't and that's because this is actually simply a table. If we went to our territory list with visual interactions on, notice that we do have, because it's a slicer the ability to make a modification here and have it affect the other visualizations. Let's turn that off, just click no, just click no. Now we've defeated the purpose of a slicer, I can click on things but nothing changes.
Just go "No, I do want it to filter." That's the funnel button and notice now when I click, everything gets modified, that works. Let's choose this visualization, let's say I don't want to allow users to click in the chart and have it modify what happens with the map or territory. In that case, just turn them off. Now, when a user clicks here notice nothing else changes.
Let's set it back the way it was with the visual interactions all working and notice once again everything works the way we would intend it to. On our district information page if I click on any one of these stores, notice that the count of name goes to one, I actually don't want that to happen. I'd like to always show how many stores I have, so I'm gonna say let's not change that. I like that the list goes to one item but do I want this to change? I don't know.
If I'd like to be able to highlight the information, that's the default we'd leave it as it is. If I want to filter the information, I'd do this. That doesn't seem like a good idea. If I want nothing to happen, I'd do that. But this highlight that we see automatically which is called cross highlighting, I like that. So now we won't change our big number tile. We will change through highlighting as opposed to filtering, there's our filter, there's our highlight, our total units last year and this year by district.
And we will allow our list to also filter. When you're all done changing those types of settings, click again on visual interactions to turn that off but notice now how nicely this works. When I choose any particular store its name comes up here, we have a highlight down here although it's a little hard to see but the count of stores in general is not changing at all.
- Signing up for Power BI Pro
- Connecting to data sources
- Uploading data such as CSV and XLS files
- Creating reports, visualizations, charts, and maps
- Filtering, sorting, copying, and pasting visualizations
- Downloading custom visuals from the gallery
- Modifying existing reports
- Creating and managing data dashboards
- Querying data with Power BI Q&A and Microsoft Cortana
- Sharing report and dashboards
- Using Power BI Desktop and mobile apps