Create a multihistogram with two different percentage fields

[sritheboss]

Blue line indicates histogram represents the % value and red line indicates the headcount info sample csv file attached can anyone help how to build this is visual in power BI

Headcount	GCB Band	Actual  %	Modelled  %
200	1	15	21
212	2	16	22
224	3	17	23
236	4	18	24
248	5	19	25
260	6	20	26

[v-menakakota · Accepted solution]

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.

[sritheboss]

Thanks

[Akash_Varuna]

Hi @sritheboss Try these steps please 

Create measures for %Modelled and %Actual using the AVERAGE or similar aggregation if needed.

Use Line and Clustered Column Chart and then add the Headcount to the X-axis, the %Modelled as a column series, and %Actual as a line series.

Customize the formatting to differentiate the lines and histogram colors.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance

[sritheboss]

Thanks