The data isn't displayed in tables, but it is displayed in Power Query

[Syndicate_Admin]

Good morning.

I load a table into Power Query, make the changes I need, and view all the data (complete rows and columns with their respective values).

However, after closing and refreshing, that same table in Table View and Report View appear with all numeric values as 0.

The tricky thing is that if I use DAX measurements on that table, it does record data.

Thanks in advance.

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

Based on my testing, the values don’t display 0. Please try the following methods:

1.Load a table into power query.

2.Add the conditional column.

3.Select Close and apply. The result is shown in Table view.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.