Forum Discussion
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
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
2 Replies
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.
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
