Only display results of Conditional Formatting Rule

[dd88]

Power BI desktop app

I am creating a report.

I have 1 tab displaying All employee data record.

With fields

System 1 EmployeeID

System 2 EmployeeID

To highlight if EmployeeIDs are different between the 2 systems, conditional formatting is applied to highlight the data.

EmployeeCodeMatch = IF(Table[System 1 EmployeeID]=Test[System 2 EmployeeID],1,0)

The results displays mismatchs and blanks.

I would like to create a 2nd tab, a Summary list to display only the employee record that have different EmployeeIDs between the 2 systems.

I looked at Filters, Basic and Advanced. However I don’t think Filters is applicable in this case.

Is there are a way to obtain only the results from the Conditional Formatting Rule to display in the 2nd tab.

How can I achieve this.

TIA

[MFelix · Accepted solution]

Hi @dd88 ,

Have you tried making a drill trough page?

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

[dd88]

@MFelix  Thanks Miguel, that was great!