Dynamic Line Chart for less than equal to selected date

[omkar333]

i want to create line chart that shows data less than equal to selected date.

like if i select 2022 its should show data till 2022.

right now its showing till 2023.ref

thanks in advance

[omkar333]

Can we have call

?

[omkar333]

Thank you for your response,

This filter is being used on the report level with all pages. 

its dificult to change the filter 

[johnyip]

Did you disable the interaction between the date slcier and your line chart?
From your layout, it is sensible that the slicer should be filtering the line chart unless interactions between them are disabled.

[omkar333]

interaction is disabled then only the chart shows complete data. 

once I enable the interaction chart showing the point as a date which is selected.

I want data till the selected date. 

[johnyip]

Simply thinking, you need to write a DAX measure in your case, not just utilizing the columns you have got in your data.

Please provide some sample data with the same data structure if you need assistance on how to wirte the DAX measure.

[DataVitalizer]

Hi @omkar333 

I suggest an altrenative solution by changing the Date slicer options.

Under the slicer settings expand Options/Style and select 'Less than or equal to'

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated