Filtering a particular column based on parameter

[Anonymous]

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!

[Anonymous · Accepted solution]

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

[amitchandak]

@Anonymous , If this is your table structure, you should try to unpivot the dates in power query.

https://radacad.com/pivot-and-unpivot-with-power-bi

Then you can have a column like this in table of date table to filter

Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA