TotalYTD or DatesYTD based on SLicer filter

[Arioli_Chezhian]

Hello everyone,
I have a totalytd measure, and creating a bar chart based on date and total sales. Also I have a slicer which contains Month Name. If I filter for March month, the bar chart will show data only for March month  but my requirement should be like the visual should display till March month (Jan, Feb and Mar). Likewise if I select June month in the slicer, the bar chart should display data from January to June.

How to achieve this, please advice.

[DallasBaba]

Hi @Arioli_Chezhian Can you try Compare from = IF (
SELECTEDVALUE ( 'Fact' [Date]. [Year] ) = SELECTEDVALUE ( 'Date dimension' [YearNo] ) &&
SELECTEDVALUE ( 'Fact' [Date]. [MonthNo] ) <= SELECTEDVALUE ( 'Date dimension' [MonthNo] ),
SUM ( 'Fact' [Amount] ),
BLANK ()
)

You can see relevant solution on

 https://community.fabric.microsoft.com/t5/Desktop/Show-data-until-selected-month/m-p/705571

I hope that work. You can share screenshot or sample data for a better suggestion.

Thanks