Forum Discussion
Helper IShowing Continuous Years on a Chart
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
Super UserHi richardburling
Do you mean something like that ?
if not please show a screenshot of the desired result.
Helper IThat'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?
- Ritaf1983
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
Hi,
Thanks for this.
It seems that you have multi-selected the years to show the data on the chart. The client has requested that they only select one year and the historical years show automatically. This is where I am stumped with this.
- Ritaf1983
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