Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hey!
I want to introduce "Select All" option in a clicket slicer.
I do have a list of qtrs like below.
What i want to achieve is - when "Select All" is clicked all available qtrs would be visible, otherwise only relevant qtr would be visible (if q1 2020 selected only data for q1 would be visible)
Could you please help me in writing this dax code ?
| Quarter |
| Q1 2018 |
| Q2 2018 |
| Q3 2018 |
| Q4 2018 |
| Q1 2019 |
| Q2 2019 |
| Q3 2019 |
| Q4 2019 |
| Q1 2020 |
| Q2 2020 |
| Q3 2020 |
| Q4 2020 |
| Q1 2021 |
| Q2 2021 |
| Q3 2021 |
| Q4 2021 |
| Q1 2022 |
| Q2 2022 |
| Q3 2022 |
| Q4 2022 |
| Select All |
Thanks in advance!
Solved! Go to Solution.