Is there any way to choose the columns within a parameter dynamically?

[TufaZ]

Hello everyone!  Can you please help me?

I have a table that contains the sales value from 2019 until 2022 and I want to create a parameter that contains all the years since 2019 until the previous year. So in 2024, the paremeter includes 2023 automatically.

For example, let's considere the following sales table.

The final objetive is to have a filter with the list of years using the parameter and to show the selected years as columns in the table as we can see in the next image.

Has anyone ever done something like this?

I've already seached for a solution but I couldn't found it.

Thank you!

[v-yueyunzh-msft · Accepted solution]

Hi, @TufaZ 

According to your description, you want to create a slicer to filter the columns in the visual.

Here are teh steps you can refer to :
(1)We need to create three measures to calculate every year value.

Sals 2020 = CALCULATE( SUM('Table'[Sales]) , 'Table'[Year]=2020)

Sals 2021 = CALCULATE( SUM('Table'[Sales]) , 'Table'[Year]=2021)

Sals 2022 = CALCULATE( SUM('Table'[Sales]) , 'Table'[Year]=2022)

(2)Then we can create a field parameter in Desktop:

Then we can modify the [Parameter] to this:

Then we can put the [Value4] to the slicer and put the [Paramter] to the value and we can meet your need:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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