The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I currently have a slicer that lists products, and then a category for 'All.' When 'All' is selected, I need that the be the equivalent of having the other 4 products selected - essentially selecting 'All' would remove any other filter. How would I do this with a DAX query, or is there another better solution?
Thanks for the help!
Current Slicer
Solved! Go to Solution.
Instead of having the value "All", select the list, go to the Visualizations pane in Power BI Desktop, click on the paint roller and under "Selection controls" activate "Show Select All Option"
Note: My Desktop is in spanish, so the menues may have a little different wording
Regards
Pablo
Instead of having the value "All", select the list, go to the Visualizations pane in Power BI Desktop, click on the paint roller and under "Selection controls" activate "Show Select All Option"
Note: My Desktop is in spanish, so the menues may have a little different wording
Regards
Pablo
Thanks Pablo, really appreciate it.
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
14 | |
9 | |
7 |