Forum Discussion

BIUser1998's avatar
BIUser1998
Helper I
2 years ago
Solved

Line Chart not plotting measure's entire data

Hello,   I have two data tables in PowerBI. One of them is called as calendar which has nothing but the names of the 12 months and the second is shown below. Month Year Value Jan 2023 38...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi BIUser1998 ,

     

    I filled in the sample data and made up 24 years of data, and the result should be what you want, please check again.

    And you can see below, there's no year field in Legend.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

BIUser1998's avatar
BIUser1998
Helper I
2 years ago

Hi Anonymous , thank you for your reply.

 

I need it to look something like this

Unfortunately, because I'm using data from other tables as well on this particular chart, I cannot just drag the Year field into legend to get a breakdown of year which is why I'm resorting to creating two measures with the data available. Thank you for your help

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BIUser1998 ,

 

I filled in the sample data and made up 24 years of data, and the result should be what you want, please check again.

And you can see below, there's no year field in Legend.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.