Cannot add MEASURE to PAGE FILTERS

[UsePowerBI]

Hello

I try to drag a measure to a page filter and it does not accept it.

How can I fix this please?

Thanks

[v-yingjl · Accepted solution]

Hi @UsePowerBI ,

In power bi desktop, measure can only be put into the visual filter, page filter is not supported. The principle in page filter is the same as that you can also not put measures into a slicer. Measure is dynamic not static, we cannot use a dynamic value to control the whole page visuals.

Workaround is just like @Tahreem24  mentioned.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

Filters accept only column value. You can not drag a measure into any filters. 

If you want so convert your measure into calculated column and then drag into page level filter.