Line and cluster visual

[Cbishop]

Hi,

I have the following data -

Month	Financial Year	Planned_Duration	Operating_Time
Apr	2019/20	315701	195523
Apr	2020/21	241547	26659
Aug	2019/20	365281	189186
Dec	2019/20	330520	174381
Feb	2019/20	340933	192965
Jan	2019/20	374639	208420
Jul	2019/20	394293	210891
Jul	2020/21	269597	108096
Jun	2019/20	338486	194002
Jun	2020/21	210256	62662
Mar	2019/20	353415	145018
May	2019/20	333453	207750
May	2020/21	247902	31021
Nov	2019/20	356647	213535
Oct	2019/20	389821	222827
Sep	2019/20	355700	205579

And want to show the Planned duration as columns and the Operating time as lines with 2 columns/lines for each financial year

I only seem to be able to get the columns split by years as per the below visual

Any help on how to split the operating time would be greatly appreciated

thanks

Craig

[amitchandak]

@Cbishop , if got it correctly. The line will not split by legend. This how it works as of now.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

[Cbishop]

 Does mean there isn't a way of splitting the line by the legend?

[amitchandak]

@Cbishop , I think so. In the line visual you can split the line, but you will not get bar.

You can check custom visual: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380768?tab=Overview

vote or log an idea -https://ideas.powerbi.com/ideas/