Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
hiren89vora
Frequent Visitor

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 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)

1 ACCEPTED SOLUTION

@hiren89vora 

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. 

 

 

 

View solution in original post

5 REPLIES 5
Daniel29195
Super User
Super User

@hiren89vora 

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.

@hiren89vora 

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






Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Based on the data which is available in the database

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.