Column Comparison Percent of progress

Hi Anonymous 

Please follow this steps .

Create a Line and clustered column chart

1. Add a field to the shared axis.
2. Add a metric to both the column values and line values.
3. Click the dropdown on the metric in the column values and select Show value as -> Percent of grand total.
4. In the formatting pane, under Y axis, turn on Align zeros.
5. In the primary Y axis settings, set the position to right. Remove the axis title and change the primary axis font color to white
6. Turn on Data labels.
7. Scroll to the bottom of the Data labels category until you see Customize series. Turn that on. Select your metric in the drop down and turn Show to of

Thank & Regards

Rohit Jaiswal