Hide Bars from Bar Chart when Values are null or 0

[bolinlee]

I create a Bar Chart panel, the x-axis is the date, and It also have some legend(Bars). For some legend in certain date, Its value is null. For such Bars that with null value, Is it possible to hide or remove them from the Bar Chart panel.
like below panel

For the “CC” Bar,On 07/24,Its value is null. But it show as an empty Bar on 07/24. I want to hide or remove this empty Bar from 07/24. That is, only show the “AA”,“BB”,“DD” on 07/24. I want to know It is possible and how to achieve this, Thank you in advance.

[yosiasz]

what is your datasource? and what does the query look like. might be better to exclude it there?

Does not seem to be possible

[infofcc3]

Hello @bolinlee you can use hide or exclude the empty bar chat using filter data by values transformation.

[yosiasz]

now try that with grouped bar charts @infofcc3