Dimension Field as Colour in Charts
I want to be able to create a basic bar or column chart and assign a colour as a dimension field. Ski Team example could be Demographic as horizontal axis, Invoiced amount as vertical and gender as colour. Seeing a clear breakdown of male and female within each demographic.
Yes this can be done with auto chart however then I can't set the formatting requirements that I want. (I want to hide the metric axis labels and lines fully).
Also I can achieve this if it's a cross tab report except that I have multiple charts that I need to create from this query and they're not possible if I make the report a cross tab.