Set colours (of which one is transparent) on stacked bar chart
Hi there experts
I have a requirement to show the range of a value as combo chart with the min and max as a bar and two points for averages. I managed to save the min, ma, BP mean and Overall Mean as master measures, set colours for each and use them to build my graph. The Min and Max are shown as stacked bar charts where the colour of the Min bar is white and the colour of the max bar (=max(value) - min(value)) is grey which shows my range. This works great, but my white Min bar covers the horizontal reference lines as is shown below:
Does anyone have an idea of how this can be solved? I would like to use something like argb(0,255,255,255) for the colour, but it seems like I can only use HEX codes for my master measures and the opacity is not contained in a hex colour code. I don't know if something like colour by expression can be used? I inherited the data load and formulas so would like not to go and change anything there.