Page filters on matrix visual

[Ma9]

I have a matrix table and want a page-level filter for one aggregation column, i am trying to  filter for greater than or equal to and less than or equal to. in the filter pane can we have this option if yes how 

please let me know  its relly helpfull thanks for the advance!

[v-saisrao-msft]

Hi @Ma9,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[Ma9]

no can we filter measures in the page filter ?

[v-saisrao-msft]

Hi @Ma9,

We cannot use measures in the Page Filters pane only calculated columns can be used there. If you want to filter based on a measure, it has to be done using visual-level filters instead.

Below is a solved thread from the community for your reference: 
Solved: Cannot add MEASURE to PAGE FILTERS - Microsoft Fabric Community

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly. 

Thank you. 

[Ma9]

Thank you, dear. As you mentioned, measures can filter at the visual level. Can I implement greater than and less than functionality as well? I want to ensure I am filtering these values correctly.

[v-saisrao-msft]

Hi @Ma9,

Yes, you can use greater than-less functionality through Advanced Filtering at the visual level. 

Just drag your measure or numeric column into the “Filters on this visual” pane, select Advanced filtering, and you’ll find options like: 

• is greater than 
• is less than 
• is greater than or equal to 
• between, etc. 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.  

Thank you. 

[Ma9]

will it work in the matrix visual as well ?

[v-saisrao-msft]

Hi @Ma9,

Yes, it will work for the Matrix visual as well.
You can apply measure-based filters in the “Filters on this visual” pane, even when using a matrix.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.  

Thank you. 

[Ma9]

I am posting here 2 screenshots before applying greater than and after applying, see the difference how its working 
1.

2.i applyed greten then 2000 and see how it filtered that column just summarized value

3 exact result i am expecting like this 

please let me know how to achive it thanks for the advance!

[v-saisrao-msft]

Hi @Ma9,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-saisrao-msft · Accepted solution]

Hi @Ma9,

Could you please check the DAX measure qtyRcdPrd? It might be affecting the visual-level filter behavior, especially if there are any conditional or aggregation logics inside the measure that prevent row-level filtering.

Also, please share a sample .pbix file so we can better understand the data model and help you reproduce the issue accurately.

If this post helps, please give us ‘Kudos’ and consider accepting it as a solution to help other members find it more quickly.

Thank you.

[v-saisrao-msft]

Hi @Ma9,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @Ma9,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data?

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Thank you.

[Ma9]

on whitch visual u r filtered i can also see greter then or less then but after adding not shoing correct values 

[Elena_Kalina]

@Ma9 Could you attach an example so I can better understand your problem and help?

[Elena_Kalina]

Hi @Ma9 

  If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!  Thank you.

[Ma9]

here the example and i filtered less then equl 2000 and see how this filtered 

[Elena_Kalina]

Reasons:

1. Filter Context. Conflict Other filters (e.g., slicers, page-level filters) or hierarchies might override your measure filter. Check all active filters in the "Filters" pane (visual/page/report level) and ensure no conflicting filters are set .

2. Measure Aggregation Issue

If  "gtyRedPrd" is a measure (not a column), filtering might not work as expected due to aggregation logic. Try to convert the filter to operate on the base column (not a measure) if possible and modify the measure to include the filter internally:

gtyRedPrd Filtered = 
VAR MaxValue = 2000
RETURN
    IF(
        SUM(Table[gtyRedPrd]) <= MaxValue, 
        SUM(Table[gtyRedPrd]), 
        BLANK()
    )

[Ma9]

values to filter dynamic not a static one attached screenshot above