Dynamically display a line

muktapurc — Thu, 26 Jun 2025 19:33:51 GMT

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

Re: Dynamically display a line

lbendlin — Fri, 27 Jun 2025 00:40:42 GMT

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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523