Forum Discussion

PaulBoden's avatar
PaulBoden
Icon for Helper I rankHelper I
3 years ago

Filter on Matrix table

Hi all,   I'm having an issue where a filter doesn't seem applying correctly in my matrix table. I'm a bit stumped as all of the underlying logic seems to be functioning correctly to populate the t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi PaulBoden ,

If I understand correctly, the visual-level filter with the condition ([#_AvailThresholdFilter] is 1) seems not working in your report. The visual should only display the data which [#_AvailThresholdFilter] is 1, but it return all data with both 0 and 1...

In order to make troubleshooting and give you a suitable solution, could you please provide some raw data in your table (exclude sensitive data) with Text format and the formula of measure [#_AvailThresholdFilter]? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards