I have a bar chart with two dimensions and an expression,
I want to present the data (Graphic) in two groups according to the possible values of the variable "Grupo" as seen in the figure, but in each of the groups if there are 3 blocks have values and 3 others have no value because are of other group. See pivot table (no graphic)
As I can do to make each group values appear only if the blocks have value?
The areas marked in red on the chart, I want to disappear.
That cannot be done using two dimensions. You can either create two charts or use only the Bloque dimension. You can use an expression to give the bars of the different groups different colors. See attached qvw.