Skip to main content

Power BI

Needs Votes

Page and report level filters on a measure

Vote (1029) Share
Merijn Campsteyn's profile image

Merijn Campsteyn on 18 Apr 2016 02:18:42

I would like to be able to apply page or report level filters on a measure. E.g. say you have a set of supplier transactions and you want to keep those suppliers where the total value of the records is above a certain amount.

Currently it's not possible to drag a measure to the filters pane and when you apply the filter on a value field it wil filter each individual record instead of the total value.

Comments (65)
Merijn Campsteyn's profile image Profile Picture

Power BI User on 06 Jul 2020 00:05:11

RE: Page and report level filters on a measure

Yes please. I am having to add Top N to each visual on each page.. seems horribly inefficient and prone to error (my errors)! So can you help us out??!

Merijn Campsteyn's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:39

RE: Page and report level filters on a measure

please

Merijn Campsteyn's profile image Profile Picture

Becky Conning on 06 Jul 2020 00:04:08

RE: Page and report level filters on a measure

This would be great. The way I envision this feature is as by dragging a measure to the filter field then being prompted to select other columns by which the measure should be grouped.

Merijn Campsteyn's profile image Profile Picture

Thijs Leufkens on 06 Jul 2020 00:04:08

RE: Page and report level filters on a measure

This would make custom relative date filters so much easier...

Merijn Campsteyn's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:03:48

RE: Page and report level filters on a measure

I would like to be able to filter pages based on measures - especially if they are text type.

Merijn Campsteyn's profile image Profile Picture

Roben on 06 Jul 2020 00:03:24

RE: Page and report level filters on a measure

let's dooo iiiiitttt

Merijn Campsteyn's profile image Profile Picture

Jaime Morton on 06 Jul 2020 00:01:48

RE: Page and report level filters on a measure

Needed!!

Merijn Campsteyn's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:01:41

RE: Page and report level filters on a measure

Please

Merijn Campsteyn's profile image Profile Picture

Daniel Olivas on 05 Jul 2020 23:59:25

RE: Page and report level filters on a measure

Wow, this goes back over 3.5 years? How come this hasn't been implemented, yet?

Merijn Campsteyn's profile image Profile Picture

DamienK on 05 Jul 2020 23:59:23

RE: Page and report level filters on a measure

I wanted to create a measure that represent X% of the global revenue and display a chart based on this measure.
I have sometime the case.