Forum Discussion
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...
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
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