Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to Solution.
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
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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |