How to modify slicers in Excel, Power Query

[mareksade]

I want to modify slicers in Excel, using Power Query, so that:The slicer is based on the Year column of a Calendar table.The slicer contains options for the years 2020, 2021, 2023, and 2024.I want to change the slicer so that when I select a year from it, all previous years are always active for that year. For example, if I select the year 2022, the options should include 2020, 2021, and 2022. If I select the year 2021, the options should include 2020 and 2021. If I select the year 2024, the options should include 2020, 2021, 2022, 2023, and 2024.How can this be done in Power Query?

 

[alansidman]

You do not use slicers in PQ, however, to achieve the same results, you need to build parameter queries. Here is a Mr E video on how to build and use parameter queries.

 

[mareksade]

tnx

 

[mareksade]

I found the solution myself on a YouTube channel. Thank you
YouTube is here -

 

[alansidman]

That is a power bi solution. You asked for a Power Query solution. They are not the same.