Forum Discussion
Solved
Show data until selected year
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 (Inclu...
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
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.