Using Measures to Filter Report Pages in Power Bi Desktop

[Fanfan_20117]

Hello,

Since 2024, it has been possible to use measures as page filters in Power BI Desktop.
I've created several reports in which I use this feature.

However, for the past few days, I've been unable to change such a measure that I use on multiple pages; I can delete it but not replace it with a new measure.

I created a new report and a new measure that I tried to add to the report's page filter: impossible!

So, it's once again impossible to add a measure to a page filter...

I've noticed this issue since the last update...

Has anyone encountered the same problem recently?

Here's my version: 2.141.1253.0 64-bit (March 2025)

Looking forward to hearing from you,

Best regards.

[andrewsommer · Accepted solution]

As other users have stated you can only use measures as a visual level filter.  We solve this problem by using the measure in a slicer and then hiding it so the end user cannot see it or interact with it.  

Please mark this post as solution if it helps you. Appreciate Kudos.

[v-sgandrathi · Accepted solution]

Hi @Fanfan_20117,

You're right, Since the March 2025 update (version 2.141.1253.0 64-bit), Microsoft temporarily disabled the ability to add measures as page filters due to stability issues. Existing measures already used still work, but new ones can't be added.

Microsoft found issues with measures in page filters and temporarily disabled the feature to maintain report stability.

There's no clean workaround for now, but you can use a calculated column instead of a measure if needed. Microsoft is expected to fix this in an upcoming update, possibly around May or June 2025.

Thank you community  members for the instant accurate response.

Please Accept as solution if this meets your needs and a Kudos would be appreciated.

Thank you.

[Fanfan_20117]

Thank you for your reply. I'll use a closed column instead, even though it's not the best solution. Microsoft should definitely do a checkup of their tool, as there are other instabilities!
Sincerely.

[andrewsommer · Accepted solution]

As other users have stated you can only use measures as a visual level filter.  We solve this problem by using the measure in a slicer and then hiding it so the end user cannot see it or interact with it.  

Please mark this post as solution if it helps you. Appreciate Kudos.

[Fanfan_20117]

Hello and thank you for this answer, even if I do not agree, having used until recently a measure as a page filter in a report. Your solution of using a segment pleases me, I just tested it and it works well. Have a good day.

[lbendlin]

Was there a white cat sitting on your lap while you concocted that?  Did you stroke it?

[AnkitaaMishra]

Hi @Fanfan_20117 , 

I checked the March Power BI update, but it still doesn't support using a measure as a page-level or report-level filter.

As far as I know, Power BI only allows measures to be used at the visual level filter. So, I recommend creating a calculated column instead, which you can then apply at the page level.

For example:
You want to filter the report page to only show employees whose age is above 30.

IsAbove30 = IF('Employee'[Age] > 30, 1, 0)

Then:

• Add this column to the page-level filter

• Set the filter to show only rows where Isabove30=1
  
  

[lbendlin]

Since 2024, it has been possible to use measures as page filters in Power BI Desktop.

That is incorrect. Measures can only filter individual visuals, they cannot filter pages.

[Fanfan_20117]

Hello, but I don't agree with you. We can't always know everything...page filtered using a measure

measure used

 Cordially

[lbendlin]

Please provide the Power BI Desktop version number where you think this was working.  Or maybe even a sample PBIX.