Barchart when the returned result is zero

[Steven_Su]

Hi, we want to create a barchart for the severity of the incident. However, we only have High incident now. The result could not show the zero for the medium and low. Is there any other alternative approach for it? Thanks.

SecurityIncident 
|summarize count() by Severity
| render barchart

[#2 · Accepted solution]

@Steven_Su 

This will create a entry for any named Severity of Zero

let Sev_ = dynamic(['High','Medium','Low','Informational']);
SecurityIncident 
|mv-expand NewSev=Sev_
|summarize Count = countif(NewSev==Severity) by Severity=tostring(NewSev)

[#3]

Thanks for the reply and it is indeed the answer I want!