Create a duplicate measure with dual axis.
Increase the size of one of the bars and change its colour to white.
You will have an outer bar in white with only borders showing
2 of 2 people found this helpful
You can accomplish this with a dual axis chart, and a bit of trickery
First, create a calculation
Then add it as the second half of your dual axis, with the first half being your other percentage.
Next, add a table calculation to your new calculation, Percentage of Total (should be 100%)
Synchronize your axis, and edit the axis to give a bit of room at the end (in the image, mine is set to 120%, or 1.2)
Color your 100% bar white, and add the black outline
From what I understood, I would try doing it in following way:
Lets say you are showing profit ratio which is 84.59%.
1. Create a field named A1:
2. Drag Max(A1) on column. Drag ProfitRatio field to the right of Max(A1). Do a dual axis.
3. Synchronize axis and edit to fixed 100
Hopefully this helps.
Thank you so much.
I have some doubts: how I create the initial dual axis chart( two bars at the same time)?
Your answer helped so much. I almost did it, but I have a little problem: I don't know how to add the black outline in the big white bar. How i have to do it?