Will it be helpful?
Follow below steps to achieve the desired output.
First drag your dimension on label and increase the height of the bars.
After increasing the height reduce the size of the bars
Step 3: Set the alignment of the label to middle centre bottom center
Step 4: Tricky part to move the labels at bottom of the bars is to edit the label and place some enter and apply and check until you don't get the desired output.
Hope this help.
Unfortunately, You cannot do that thru positioning.
But, If you really need this, I can provide some magic.
copy value field, and put measure value to column and put both field into it.
Change the color of bar of bottom Measure to "white"
- double click color and select white
Change the font color of Category to same color as bar chart.
Color Change_SM_9.2.twbx 25.7 KB
Thanks for responding.
I had tried this trick before as well, it works when the number of horizontal bars are less or constant, in my case it varies, based on the parameter that i select. Hence, what is happening is that the alignment goes for a toss.
I was thinking for a quick hack like this:
say i duplicate the measure and stack them side by side, then shade of the bar as 100% transparent / no color, basically the bar exist but doesn't show.
then label the second bar. Doing this i guess, the alignment will be maintained irrespective of the number of horizontal.
I was thinking too much trickily
Because I was working couple of heavy questions today, my head tends to think very complicatedly.
That's my bad.
Yours is pretty simple. That solution should have hit my head soon.
You're right sir! Initially I was thinking about dual axis, text etc then I thought instead of making it complex I should think simple so I came up with this . I guess your solution is the answer of the requester.
Thanks Mahfooj & Shin,
I got what i was looking for.
You are very welcome!