It is possible.

You can create an IF-THEN calc leveraging DATEADD() to define the range to show. Then, you can exclude what is out of range. This will work dynamically.

If you insist on having the labels as they are in your example, you need to create an IF-THEN-ELSEIF string calc to compare the date to your calc (e.g. IF date_variable = DATEADD(“day”, -1, parameter THEN “Day -1” ELSE IF...END) Both the date_variable and the new calculated field pills need to be dropped into columns. Then you may hide the date values header if you wish.

If any of your metrics include window calcs, it’s still possible, but a little more tricky.