Line and bar graph; bar graph is okay, but line graph is showing one line only

[Orstenpowers]

Dear all,

I hope you can help me...

Below you do see my table and the related graph.

The bar chart, indicating the cumulated amount, is correct.

Unfortunately the line graph is not, as it shows the values of the column highlighted in yellow. However, I would have expected two lines illustrating the values of the column highlighted with blue.

In the end, this visual should show

two lines, comparing the results by month (incomlete)

two bars, comparing the cumulated results by month (completed)

Anybody here who could help me?

[amitchandak · Accepted solution]

@Orstenpowers , As of now power bi does not split line based on legend in this visual.

Check for custom visual or log and Idea.

Or create measure for this year and last year

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA