Forum Discussion
Solved
Default slicer selection which changes with every time when a new data is loaded
I have 12 quarters of data in slicer, need a dynamic slicer which will select default 2022 Q4, 2022 Q3 and 2021 Q4 and other quarters should be visible and user can select those if required. 2020...
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.
Hi hiren89vora
What is the logic for selected Quarter means How you decided this quarter should be selected.
2022 Q4, 2022 Q3 and 2021 Q4
Based on the data which is available in the database