How do i align the line values with the column series in the line and clustered column

[Anonymous]

Age bracket table

I have above a table with the Age which link to the to an age bracket table . Using the line and clustered chart the column series is Gender and the column values is AvgAccountBalance is aligned according to the Gender. However I can't align the linevalues of the Numberof Member Account into Gender. For example for <25 expecting one values for M and F.Can you help please

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can refer the following blog to achieve it.

Solved: Re: Clustered bar chart with bubbles for each bar ... - Microsoft Power BI Community

Best Regards

[Anonymous]

Above is the current chart . Need two line values by Gender. need the Line values to align with the column series

[amitchandak]

@Anonymous , In clustered line viusal. Line will not split by legend. You need to create two measures with gender filer and use those

[Anonymous]

I did crreate two measures for the difference gender. What i need is the black line((dot) F to appear in the column series Gender F (dark green) colour and the Green Line (dot) M to appear in the gender M (orange) column according to the column series.