Forum Discussion

hiren89vora's avatar
hiren89vora
Frequent Visitor
2 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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:

    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":

    Get the visual

    Create the Preselected Slicer

    Fianl output

    If you want to restet, you can click the button

     

    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