Marten Menke on 30 Mar 2017 20:38:03
Say we have a barchart that display the sales percentages for 10 different products in the current month.
We also have a linechart that displays the total average sales percentage per month, for both the current and last year.
When you allow the barchart to interact with the linecharts, currently both the product AND the month are set as filters on the linechart.
Instead, I would like to select which interactions apply. In this example, only the product should filter. That way when you select a product in the barchart, the linecharts display the sales history of that product (rather then only a dot for the current month).
- Comments (4)
RE: Advanced interactions
Great idea, I have exactly the same issue. sales data that has different time contexts in each visualization but we want to pass the customer selection between them. I have had to resort to specialized measures for each so I didn't have to use Visual Level Filters. Allowing to choose to pass Visual Filters or not along with the selected item would be a huge benefit.
RE: Advanced interactions
The Power BI team should spend some time playing with Tableau to see how that product allows for incredibly deep insights through filtering and highlighting actions between visuals. The user can specify which dimension(s) of data the filter should act on.
RE: Advanced interactions
Visual level filters should not impact other visuals...that's why they are visual level filters and not page level filters.
I have a waterfall chart that shows the components that makes up the current year-to-date net growth (a visual level filter is applied to only show the current year) and a line chart that shows cumulative growth by week with year-over-year comparison. When I select a component on the waterfall chart it cross filters my line chart and removes the historical years (which is what I am interested in seeing). If it where a true visual level filter, it shouldn't filter any of my other visuals.
RE: Advanced interactions
to be complete: also the "visual element filters" of the barchart are applied to the linechart