Skip to main content

Power BI

New

Slicer - allow filtering on a measure

Vote (40) Share
Mads Brink Hansen's profile image

Mads Brink Hansen on 24 Apr 2018 16:41:28

The slicers are great - (especially after introducing the responsive slicers) - but are somewhat lacking as they cannot be filtered on a measure (think a table - but not showing the measure) to make the slicers showing only relevant items. Furthermore, the selected items should appear first in the slicer (independent on the otherwise alphabetically sorting)

Comments (3)
Mads Brink Hansen's profile image Profile Picture

fd30e85b 8e6e-4c5f-aaa4-51638ce5608b on 05 Jul 2020 23:44:59

RE: Slicer - allow filtering on a measure

Would be very useful in combination with functions like RANKX.

Mads Brink Hansen's profile image Profile Picture

52973782 217b-4723-b424-f80104a56216 on 05 Jul 2020 23:37:49

RE: Slicer - allow filtering on a measure

Even Marco Russo agrees!

http://disq.us/p/1y84csd

Mads Brink Hansen's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:18:12

RE: Slicer - allow filtering on a measure

make a summarize columns table and keep the created measure into that summarize table then we can use measure as filter try that .