Show All Categories (Including Zero Values) in Bar Chart

Looker Q&A Looker Studio
1

Hi, I am using the Google Sheets connector to bring my database to the dashboard. However, in a column called “Status”, I have 5 options that can be chosen by the user. As of now, he has only entered 4 of the 5 options, making one of them not appear in the database.

Those 5 options are:

“En entrevistas”, “En proceso”, “En propuestas”, “Solicitud de documentos” and “Psicométricos”.

In my dashboard, I have a Bar chart where I put how many times those status were selected. What I want to happen is that the status that hasn’t been selected appear and show 0. And all of that, I want it to happen without affecting the multi-filter option with every graphic of the page (everything is connected and responsive).

Right now, my bar chart looks like this:

alejandrobarce1_0-1742343008192.png
alejandrobarce1_0-1742343008192.png804×405 15.8 KB

I would like that the status “Psicométricos” appeared too with a 0.

Hope I made myself clear :slightly_smiling_face:

2

Hi, have you tried using someone else’s dashboard? Also, try entering numbers such as 1, 2, 3, 4, or other values into the missing data fields to check if the data appears.