Forum Discussion
2 level y axis
Zyg_D you can use matrix visual and use bar chart for amount in conditional formatting.
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?
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.
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.
