Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Q1
2020 Q2
2020 Q3
2020 Q4
2021 Q1
2021 Q2
2021 Q3
2021 Q4
2022 Q1
2022 Q2
2022 Q3
2022 Q4
And everytime if new quarter is uploaded to the data, then the slicer should change the selection (current, prior, prior year same quarter)
Solved! Go to Solution.
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.
you can use the approach from these 2 youtuube videos :
https://www.youtube.com/watch?v=JlVHsZUk1nc
https://www.youtube.com/watch?v=VaJ10ilXp6Y
let me know if this helps with what you are aiming for .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
68 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |