Create a multihistogram with two different percentage fields

Hi sritheboss ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

After reviewing the issue,Power BI doesn't technically support "multihistograms" as seen in statistical tools, I believe what you're trying to achieve is a multi-series visual that compares headcount and percentage values side by side for each GCB Band essentially combining both bar and line chart elements in one view.

You can create this using Power BI’s built-in Line and Clustered Column Chart. First, load your data with columns for GCB Band, Headcount, Actual %, and Modelled %. Then, use GCB Band as the X-axis. Assign Headcount to the column values, and both Actual % and Modelled % to the line values. This will give you a grouped visual where Headcount is shown as bars and the percentages are overlaid as lines on a secondary Y-axis. You can customize line colors, axis formatting, and labels for clarity.
Please go through the pbix file which i have shared.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.