Dashboard for tenants with no elasticsearch log values

Using Grafana 9.2.2

I want to make a bar chart showing a count of a specific elastic search log message grouped by the “tenant” field in log message. I would like to include a bar (with a zero value) for tenants that do not appear in my search. I have a list of all the expected tenants, that I could put into a variable and use, but I don’t know how.

I tried to add a query for each of the tenants, but it seem that a bar chart does not support multiple count queries.

I can make a simple “group by term” bar chart, but this of course does not show the tenants with no log entries.

Something other than a bar chart could also work for me. I just want to get a clear view of tenants where nothing is happening.