Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

Reviewing the data that was filtered out of the dataset

I am trying to recreate a set of reports a previous employee created and would like to review the data that was filtered out in one of the steps. How can I review the removed data?

Super User
Super User

Just click on the step before the filter step.



I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

Let me try to further clarify.


The step prior to the filter is a Change in Data Type. And then the filter just says for Each True. There are no other indications of what was filtered out, unfortunately. I was hoping the Advanced View would articulate what was filtered, but it doesnt either.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors