I have the following bar chart:
As you see there are two measures, some data points have zero values for both of them and some have mix.
I don’t want to show data points where both measure are zero, but need to keep those where only one of the measures is zero.
Filtering on measures does not help as it removes all zero data points and non-zero values from another measure.
in the data section of your Explore, do you have the option activated for the Dimension Fill on the dates?
If so we can remove this which will not display these rows in the visualization.
Also another way to hide certain rows is to use a table calculation that will yield a boolean yes - no value for the rows. Then, on the header of the column for the table calculation, we will have the “Hide Nos from Visualization” option as showed here. This will allow to hide specific rows from the final visualization.
I hope this helps, if you have any questions feel free to reach out to us at help.looker.com
Thank you Romain! Helped a lot!