Have a bar chart show a bar of 0

Question & Answer
1

I have data that has 4 possible values for the x-axis (A, B, C, D). With the filter I have applied to my visual, it only returns data that has values of A, B, and C.

Currently, since D is not returned from the filter, all that shows up in my bar chart is A, B, and C with their respective counts.

Is there a way where I can get the bar chart display column D, as an empty bar with no height?

2

This is not possible with a filter.

You might look to make a parameter that has a control and then make a calculated field that looks at the parameter.

Something like this.

ifelse(${parameter}={name_field},{value},0)

Then use this ^ as your value and don’t filter.