How to show the statistics of missing values of all fields in Power BI?

[Sahar_lt]

Brand new to Data Analytics! I'm new to Power BI and facing some issues. I ppreciate if anyone could help. I'm trying to visualize the number of missing values of all fields in one column chart. So in X-Axis, I should have all columns of dataset and the value should be the number of missing values of each columns of the dataset.

Can anyone help me with this? 

[Anonymous · Accepted solution]

You can also get this info by adding a new blank query, and using =Table.Profile(TableName) as the source.

--Nate

[fe_username]

The best way would be to 
1) Fill all the NULLS in your table
2) Selecting a column that contains unique values (Like an ID or Name) and select unpivot other columns
    Mind that in a business contest, UNPIVOT can be extremely taxing on resources and your table could add up to 30 Milions or more
3) Put it on a Stacked Chart

The same thing could be done also in SQL

[Anonymous · Accepted solution]

Hi @Sahar_lt ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[Anonymous · Accepted solution]

You can also get this info by adding a new blank query, and using =Table.Profile(TableName) as the source.

--Nate

[Sahar_lt]

Thanks for replying. Actually I want to show the number of missing value of all feature in one visual.

I have done it in another way. First I unpivot the table in Power Query Editor. 

Then I created 2 measure for calculating blank and total values for attributes and then in my StackedColumnChart I put this measure as value.

 

[Iohanney]

Hi! Can you please explain in details, I cannot do it. 

[AlexisOlson]

I'd recommend checking the View tab and see if the statistic you can show with those options are sufficient.