2 level y axis

[Zyg_D]

It may be that I miss something very obvious. Sorry, I am new and struggling...

My data table:

I would like to obtain a graph which looks like this one made in Tableau (note 2 clearly separated columns on the left):

The closest I could get was the graph below. But for levels with longer labels, concatenating labels like this looks too much of a clutter. I would love to find a way to separate levels into 2 nice columns like in the graph above.

[parry2k]

@Zyg_D you can use matrix visual and use bar chart for amount in conditional formatting.

[Zyg_D]

@parry2k- thank you for the reply. The result looks like this:

This may help in some cases, even using the example that I posted. But it has unnecessary totals/ subtotals and in doesn't explicitly show another column with its respective title. Also, it cannot show the x axis with labels. It seems to be rather a workaround than a solution. In this way, I cannot change the type of the graph to e.g. stacked 100% bar chart. This is what I originally was expecting to receive, while the given example is oversimplified, my apologies. In Tableau it is possible to get stacked bar chart together with 2 columns of categories. Would you have any suggestion if I wanted a stacked 100% bar chart?

[parry2k]

@Zyg_D you can put level1 and level2 on x-axis and drill down to level 2, in bar chart you can turn off "concatenation labels" off, that's the only option you have for now or use matrix.

[Zyg_D]

It seems, this is exactly what I tried in the question, only on different axis. Drilling down may be good for web interaction, but this time I will have to print it. 2 columns would be easier to understand than concatenated text.