Forum Discussion
Default slicer selection which changes with every time when a new data is loaded
if you create create a column,
that will contains date values, + ( current, prior, prior year same quarter as text ) >
so you will have a column in your table with the following values :
date_modeled
2021-q1
2022-q2
2022-q3
2022-q4
...
current quarter
prior year same quarter
prior quarter .
now, you can drag this column to the slicer, and choose the last 3 as pre selecteed.
nope, i need the selected quarter to be visible rather than default, and also i need past quarter visible too but not selected.
if you create create a column,
that will contains date values, + ( current, prior, prior year same quarter as text ) >
so you will have a column in your table with the following values :
date_modeled
2021-q1
2022-q2
2022-q3
2022-q4
...
current quarter
prior year same quarter
prior quarter .
now, you can drag this column to the slicer, and choose the last 3 as pre selecteed.