Data in report does not match Query data for single cell

[TobiasKitchen]

Hi,

I'm having a very strange issue with a report I'm trying to run on the Power BI desktop application.

I have source data in two tables that is taken directly from SharePoint and has been merged. It is correct in both the query and on SharePoint itself.

However, on the report - a single cell is incorrect. It is a simple yes / no column and the cell states "yes" instead of "no."

I have tried many things with filters / transforming / replacing query data but nothing seems to work.

As it is just one cell - is there a way to manually change this on report level?

I don't have good knowledge of DAX and am fairly new to the system so some help with this would be hugely appreciated.

Thanks 🙂 Tobias

[TeigeGao]

Hi @TobiasKitchen ,

Have you checked the data in the PowerQuery (edit queries)? Generally, the data will not be changed when importing into PowerBI.

If the data is not true in PowerQuery, we can use the Table.RemoveRows() M function to remove the wrong row, then add another table with a row with true data manually, then append these two tables.

Best Regards,

Teige

[TobiasKitchen]

Hi @TeigeGao,

Thanks very much for getting back to me.

I managed to solve this one - error was in one of the queries - now fixed.

Really appreciate the help 🙂