Forum Discussion
Continued Contributor2 level y axis
Super UserZyg_D you can use matrix visual and use bar chart for amount in conditional formatting.
Continued Contributorparry2k- 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.