Forum Discussion
Showing Continuous Years on a Chart
Good Morning,
I have had a request from a client to display a line chart with three years worth of data on it, that is displayed in a continous line. So as one year ends, the next one starts. It also needs to be controlled by filter selection, so if you selected the financial year of 2020-21, then it would need to show the two previous years.
I have been looking around the forums and youtube videos but cant seem to find a method that works for me. If you can offer any assistance, I would be very grateful.
Have a good day.
RB
Hi richardburling
Do you mean something like that ?if not please show a screenshot of the desired result.
Hi richardburling :
You should create a calendar table that will be related to the transactions table like :The tutorial for creating a calendar is here :
https://www.youtube.com/watch?v=Lt_nNLQz0IE
Then on slicer put a year from the calendar table:
Use the needed granularity as a hierarchy of the graph (X-axis from date table again):
PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
richardburling
You can use dax to manipulate the years.please refer to the linked discussion:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
6 Replies
Hi richardburling
Do you mean something like that ?if not please show a screenshot of the desired result.
That's it!! Only my data is based on 52 weeks rather than 12 months but thats it.
Can you please point to where I can find out how to build this type of chart?
Hi richardburling :
You should create a calendar table that will be related to the transactions table like :The tutorial for creating a calendar is here :
https://www.youtube.com/watch?v=Lt_nNLQz0IE
Then on slicer put a year from the calendar table:
Use the needed granularity as a hierarchy of the graph (X-axis from date table again):
PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
