The table was created by using dual axis for the data values and a combo of calculations.
How: Used a calculated fields called Column header and added details to the marks card.
Then double added them - used the dual axis feature to show them on one column. Now the issue is no matter what I do I cannot get it right aligned. I also tried to use formatting alignment and also the stack marks alignment is turned off. (that was one of solutions discussed in other forums)
@Manisha S
Hi, attached you will find a workbook with your requirement.
a. I changed the pills in columns to 1, and used them as Dimension.
b. For the first 1 pills, I changed the mark to polygon. (This removes the marks)
c. For the second ones I used Gannt Charts, I aligned the text to left, I completely washout the color.
d. In the dual axis, I edit the range to fixed from 0 to 1 (show the header, double clic in the axis, fixed, 0, 1)
e. I removed the background lines by formatting, in lines, columns, I removed grid and zero lines.
If this post resolves the question "Select as Best" or if it assists in resolving the question, please "Upvote". This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego
