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.
Select all for Slicer doesnt work.
When I select "select all" in the slicer it doesnt do a thing in "count of part name prob by year and prob descp" chart.
I have a separate slice create so that I can select only certain values in that slicer, and I want the select all in that slicer to work.
Can someone help ?
In Slicer, Select ALL or Select none has the same meaning. This means there is no filter on this parameter. If your slicer behaving differently, let us know.
In Power BI slicers, by default nothing is checked but it is still a Select All (instead of Select None, as you would expect). So if you have nothing checked, and you hit Select All, you will not notice any change as the filter is same. Try Select All and uncheck a couple of values and notice the difference.
Regards,
Tarun
@amitchandak @tarunsingla I forgot to mention that the slicer that I have highlighted does not have all the parts in it. So "Select All" only means select/select none of all the mentioned parts below. For eg: In the field Part Name Causing Prob there are 35 lines but the slicer I have built for the same only has 9 lines. So when I choose to "Select All" it should only select those 9 lines that are in the slicer right ?
THe report that you includes those 35 lines but when the filter is applied it should only show the data for those 9 selected lines from the slicer.
Does that make sense ?
"the slicer I have built for the same only has 9 lines. So when I choose to "Select All" it should only select those 9 lines that are in the slicer right ?"
I assume you mean you have a page level filter applied (on that field) on this page of the report. So yes, Select All would select only those filtered rows.
"THe report that you includes those 35 lines but when the filter is applied it should only show the data for those 9 selected lines from the slicer."
Not sure if I understand it well, but if you are referring to the bar graph on the top right corner of the page, it seems to be showing the view of Prob Desc field. How many distinct values do you have for Prob Desc, for that filtered list of Part Name Causing Prob? Is it 9 or is it more?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
65 | |
45 | |
39 | |
31 |
User | Count |
---|---|
164 | |
111 | |
61 | |
53 | |
38 |