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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
hiren89vora
Frequent Visitor

Dynamic selection on Slicer

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

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

Hi @hiren89vora ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

vheqmsft_0-1709606607436.png

Create a table 

Table 2 = 
    DATATABLE(
        "Dirty Status",BOOLEAN,
        {
            {"True"},
            {"False"}
        }
    )

For the slicer that comes with Power BI, we cannot get it. But we can get the three points in the "Visualizations", please click the "Get more visual":

vheqmsft_1-1709607246823.png

Get the visual

vheqmsft_2-1709607281029.png

Create the Preselected Slicer

vheqmsft_3-1709607351440.png

Fianl output

vheqmsft_4-1709607381320.png

vheqmsft_5-1709607406067.png

If you want to restet, you can click the button

vheqmsft_6-1709607451937.png

 

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

View solution in original post

2 REPLIES 2
v-heq-msft
Community Support
Community Support

Hi @hiren89vora ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

vheqmsft_0-1709606607436.png

Create a table 

Table 2 = 
    DATATABLE(
        "Dirty Status",BOOLEAN,
        {
            {"True"},
            {"False"}
        }
    )

For the slicer that comes with Power BI, we cannot get it. But we can get the three points in the "Visualizations", please click the "Get more visual":

vheqmsft_1-1709607246823.png

Get the visual

vheqmsft_2-1709607281029.png

Create the Preselected Slicer

vheqmsft_3-1709607351440.png

Fianl output

vheqmsft_4-1709607381320.png

vheqmsft_5-1709607406067.png

If you want to restet, you can click the button

vheqmsft_6-1709607451937.png

 

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

lbendlin
Super User
Super User

I know what you are trying to do, YoY and QoQ.  There is no default filter that can handle that scenario but you can kinda fudge it if your calendar table gets refreshed sufficiently frequently.  Then you can include a calculated column that can include that default selection.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.