TIP - Filtering Slicer Selection

[Heather]

We have all had instances where we use a slicer in our data, but get frustrated because it does not get filtered to the appropriate data based on other filters.

Example - my datasource includes 30 sales people, but only 10 should show in the slicer for the dates I have selected.

I have seen a variety of solutions for this, including bi-directional filters on the two tables (Sales and Salesperson).

But in this video from BI Elite, Parker shows a very elegant solution.

Now, the point of this video is actually to show how to slice data based on the results of the Total Sales measure (which is an interesting trick as well) - but at the 6:41 mark, he then filters the disconnected slicer table to show only relevant data based on the visual. This is done with a virtual table. Really cool trick and I’m going to need to add to some of my existing reports.

Power BI - Filter by a Measure in a Slicer

[Heather]

a few keywords, and marking this as solution.

Slice to Relevant Values, Slice to Relevant Members, Slice by Measure Result

[BrianJ]

@Heather,

Seems this one made a big impression on both of us…

TIP: Filtering a Visual by a Measure in a Slicer

The question of “how can I use a measure in a slicer?” comes up pretty regularly on the forum. The answer is that (generally) you can’t - Power BI doesn’t support the use of measures in slicers. However, there are some clever workarounds you can implement if you need this functionality, and Parker from BI Elite posted a video today with a really ingenious solution. If you need to be able to do this (or if you’re just a fan of clever PBI techniques), I definitely recommend checking this out: …

• Brian

[Heather]

I hadn’t seen that yet Brian - moderators, feel free to delete this if you don’t want the duplication.

Honestly - for me, the neat part wasn’t about filtering the measure by the value, but filtering the slicer to only show relevant values