Forum Discussion
Help
You can accomplish this with the line and clustered bar chart visual.
- Change to chart line and clustered bar chart
- Add the percent to the line field. You can simply re-add Headcount and change to show as % of total
- Then, assuming you don't actually want the line showing, change the stroke width to 0 in the format options
Result:
Edit: Additional display setting considerations. For more consistent positioning, you can change Secondary y-axis > Range > Minimum to 0 and set Data label > Options > Position (column) to Inside end. And for cleaner style, it also makes sense to hide the secondary axis (turn off title and overall axis after setting minimum) and legend.
- Change to chart line and clustered bar chart
You can accomplish this with the line and clustered bar chart visual.
- Change to chart line and clustered bar chart
- Add the percent to the line field. You can simply re-add Headcount and change to show as % of total
- Then, assuming you don't actually want the line showing, change the stroke width to 0 in the format options
Result:
Edit: Additional display setting considerations. For more consistent positioning, you can change Secondary y-axis > Range > Minimum to 0 and set Data label > Options > Position (column) to Inside end. And for cleaner style, it also makes sense to hide the secondary axis (turn off title and overall axis after setting minimum) and legend.