Forum Discussion
Line and cluster visual
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
3 Replies
- amitchandak
Super User
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
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/
