topic Dynamic selection on Slicer in DAX Commands and Tips

Dynamic selection on Slicer

hiren89vora — Mon, 04 Mar 2024 07:24:46 GMT

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

Re: Dynamic selection on Slicer

lbendlin — Mon, 04 Mar 2024 18:46:42 GMT

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.

Re: Dynamic selection on Slicer

Anonymous — Tue, 05 Mar 2024 02:58:36 GMT

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