Skip to main content

Power BI

Needs Votes

Implement an option for "Select All Current" in basic filtering.

Vote (1) Share
Jonas Baard's profile image

Jonas Baard on 08 Nov 2018 21:17:18

Implement an option for "Select All Current" in basic filtering for a filter.

When filtering with 2 fields, lets say CustomerNo and Period and showing the sales for a category.
We need a way to select all the current CustomerNo´s showing with the current filtering, then filter Period on another period
but with the same CustomerNo´s from the previous selected period.

When I select Period the CustomerNo filter are filtered since they have no sales, we would like to "Isolate" these customers.
When I use the "Select All" in basic filtering for CustomerNo and unfilter my period the previous filter "Select All" for CustomerNo´s does not stick.