Suppress zero Values in Bar Chart with two Dimensions

[timweidner95]

Hello,

I want to create a Grouped Bar Chart with two Dimensions [Region] and [Gruppe] with Values as Expressions from year 2018 and 2019.

Now there are some zero Values because there are no Data for this Dimension but they are shown in the Chart.

Can anyone help me, that just the Values are shown that are not zero?

Thank you.

Kind regards

Tim

[Gysbert_Wassenaar · Accepted solution]

That's because you're using two dimensions. For each value of the first dimenion space is reserver for all the values of the second dimension even if there is no result for that dimension value.
You could try concatenating the values of the two dimension to get one dimension with unique values: =[Region] & ' - ' & [Gruppe].