Forum Discussion
Basic filtering not showing same results as advanced filtering in filter pane
Hi,
I have a strange situation with a filter on the filter pane. When I filter with an advanced filter, my report will show the data filtered by this Product:
However when I filter with the basic filter, the item does not appear in the search of the filter, and the report cannot be filtered for this product:
Does anyone know what might be the cause?
Thanks.
Evelien
Hello EG2025 EvelienG2026 ,
There can be reasons such as datatype of the column, if there are any spaces around the values in the column. One must validate the datatype and validate if there are any trailing or leading spaces in the value. You can transform the data in Power Query Editor using Transform>Format>Trim.
Please let me know if this didn't help.
Thanks.
6 Replies
- SamWiseOwl
Super User
Does that item show up in the Basic Filtering list when you have NOT applied a filter?
There have been issues with the Filter Pane when you change the Theme.
Are you using something other than the default:
Hi SamWiseOwl, sorry I am the same person as EG2025, but for some reason I had to choose a new username in order to reply 😉
I cannot see the item in the list when I do not apply a filter.
For me the option from your screenshot is also set to "Legacy"
Hope this helps.
Thanks!
rajulshahResident Rockstar
Hello EG2025 EvelienG2026 ,
There can be reasons such as datatype of the column, if there are any spaces around the values in the column. One must validate the datatype and validate if there are any trailing or leading spaces in the value. You can transform the data in Power Query Editor using Transform>Format>Trim.
Please let me know if this didn't help.
Thanks.
v-sgandrathiCommunity Support
Hi EG2025 EvelienG2026,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!- v-sgandrathi
Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you've already resolved the issue, you can mark the helpful reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for your cooperation!
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.Thank you.
- v-sgandrathi
Hi EG2025, EvelienG2026
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.
