Show data until selected year

[KevinRDynasoft]

Hello,

I'm using chiclets but I could use a slicer. If I select a year, the page will only show data of that year but I want to show all the data of all the years before the one I selected (Including the one I selected obviously). I'm using a rolling calendar

[V-lianl-msft]

Hi @KevinRDynasoft ,

Create a new table using the years in the original table and use it as a slicer.

Create a measure and apply it as a visual filter.

Measure = IF(SELECTEDVALUE('Table'[year])>=MAX(test1[year]),1)

You can refer to the pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

hey

try like this 
it should work

[Pragati11 · Accepted solution]

Hi @KevinRDynasoft ,

Have you tried Relative date slicer in this case?

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Thanks,

Pragati