Dynamically display a line

[muktapurc]

Hi All, 

I need a help . I want to display annual production line which will be plotted in x axis.  

We have two slicers 

1. crs_period

2. midas_data 

crs_period contains years

midas_data contains values in the form of 

2021-1-ls 

2021-2-cs

2021-3-fs

2021-4-su

This will continue for other years with same combination 

This is my measure :

VAR crsy= SELECTEDVALUE('signficant'[crs_period])

VAR midasy= SELECTEDVALUE('signficant'[midas_period])

RETURN 

DIVIDE(calculate(

                            DIVIDE(CONVERT(SUM('Significant'[production]),INTEGER),1000,0),

'signficant'[crs_period]=crsy && ('signficant'[category]<>"is_plan_metrics_empty" || 'signficant' [value]<>"2")),2,0)

Requirement: when we select two slicers then I should get a line plot . The line plot should show one year back data 

Example: 

slicer 1 that is crs_period : 2022

Slicer 2 that is 2023-3-fs 

Then line should show 2022-fs 

Based on slicer 2 year then line should give one year back data based on midas_period.

Midas_period is a column which contains data .

Here is the format 

2018-cs

2018-fs

2018-su

2018-ls

Same will be continued for next years 

Both slicers will have single selection on 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...