Data source with missing value presentation

[alvin199]

Hi,

I would like to know how should I present the visual with missing value.

I have 1 bar chart (show Number of Student in Class) and a card (show Total Number of Student Registered in the school).

However, there are missing values for the Class column. Thus, if I remove the missing value of the Class cloumn in the Transform Data page or exclude it in the Filter panel of Report view then it will display the Total Student in the Card and Total in the bar chart (adding the total of each bar) with different value.

What is the correct presentation without mislead the users?

[Anonymous · Accepted solution]

Hi @alvin199 ,

Create a measure named like "count of students have class".

count of students have class = CALCULATE(COUNT('Table'[student]),FILTER('Table','Table'[class]<>BLANK()))

Best Regards,

Jay

[alvin199]

@amitchandak 

Hi, here is the sample pbix file

https://drive.google.com/file/d/1omVSGJNxGTa_Y8L0OdaXi2rWr8EfROaX/view?usp=sharing

There is a missing value in Class cloumn. I have replace the Null to 0 in Transforme Data page.

If I include the class 0 (which suppose does not have class 0) then the Total number will be fine but visual is not make sense. 

If I exclude the class 0 in the bar chart, the Total Number for both Card and Bar chart are differnet. 

The data owner does not know what is the appropriate class for the misisng value due to some reason thus I put class 0 for the Null value as a flag. 

[amitchandak]

@alvin199 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.