Start line graph at year selected in slicer

[Wattar]

Hello,

I have years in a slicer and a line graph, and I need to display data starting from the year selected in the slicer? How to do that?

Thanks for your help.

[Anonymous]

@Wattar 

You can put your sample pbix file on Onedrive for business, and then share the link here. 

Paul

[Anonymous]

@Wattar 
Basically, you need to create measure to make visual dynamic, and "enter value " create a slicer table, the the new Year column as the slicer. Check the example pbix for detail.

Value Measure = CALCULATE(MAX([Value]),FILTER('Table',[Year]>=SELECTEDVALUE('Table (2)'[Year Slicer])))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Wattar]

@Anonymous , thanks for your reply.

It seems right but I couldn't reproduce your solution.

I can't find how to upload my workbook.

Thanks

[Wattar]

I hope it's clear with an image, the grpah displays all the years where there are data, but I need to only show the years starting from the year selected in the slider:

[ryan_mayu]

@Wattar 

could you please share the sample data and expected output?

[amitchandak]

@Wattar , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.