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

Adding keywords for search: slicer, measure, filter, GENERATESERIES, virtual table, BI, Elite, Parker.