Help with Line Chart

[Anonymous]

Hello!

When I was trying to add a line chart that shows headcounts by month, the chart shows only the current selected month instead of showing all months. Am I missing something? 

Here's what I have right now

And here's what I need to get:

Thank you!

[parry2k]

@Anonymous not sure what column you are using for x-axis, you should use month on the x-axis and then you can slice it on a year and you will see all the months for that year.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[amitchandak · Accepted solution]

@Anonymous , if you select one month and want more than that on axis, you need an independent table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -7) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI