Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Everyone,
I have a slicer in which i have "select all" option and i want to show two other option appliying visual level filtered from the slicer values.
Example :
Scenario is :-
When user is selecting select all option the two other two option(Compliance and Premier) which i have provide should be excluded.
But he can select the other two option avaliable individually as an example if he select compliance than he will see filterd value of compliance only.
can ayone help me to achieve this @Ahmedx , @amitchandak , @Ritaf1983 , @Fowmy , @lbendlin .
Solved! Go to Solution.
Hi All,
I got the working solution for this requirement instead of having select all slicer and filter option, i have calculated a table wherein i have two other option which i wanted and the rest is select all with the swtich statement.
Hi All,
I got the working solution for this requirement instead of having select all slicer and filter option, i have calculated a table wherein i have two other option which i wanted and the rest is select all with the swtich statement.
When user is selecting select all option the two other two option(Compliance and Premier) which i have provide should be excluded
No, "Select All" literally means "select all". Meaning "include all".
Keep in mind that "Select none" is the same as "Select All" in Power BI world.
Can you give me other way around to give user an option to do the following.
1. Select All ( he should be able to select all option excluding the other two option)
2. Select one option which in our case is suppose "Compliance"
3. Select one option which in our case is suppose "Premier"
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
62 | |
54 | |
38 | |
25 |
User | Count |
---|---|
84 | |
60 | |
45 | |
41 | |
39 |