Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filtering a particular column based on parameter

Following are my column headers:

I have a parameter which dynamically changes everyday, i want my dashboard to use a different column based on the parameter value. That is, if my parameter has 13/02/2023, i want my powerBI to filter the 13/02/2023 column from the above table.

If it helps, the parameter updates to today's date everyday, so basically i want my PowerBI to filter today's column, everyday. If this can be done without the need for a parameter, I would be happy to see that solution as well.


Is this possible?

Thanks in advance!

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Rather than unpivot, I transposed the data to have the dates in rows, and filtered the row based on the parameter
    Column1 is the transposed date column, MaxDate is my parameter.


    I did another transpose again, to get it back as a column

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Rather than unpivot, I transposed the data to have the dates in rows, and filtered the row based on the parameter
    Column1 is the transposed date column, MaxDate is my parameter.


    I did another transpose again, to get it back as a column