Forum Discussion
Heirarchy filter problem with select all
I am currently using the Heirarchy slicer and I'm running into a problem when the user clicks on the "Select All" it returns an error like the below.
If the user selects just 1 item from the filter no problem. I currently have 6 items in the list and they can select up to 5 of them with no problem. When they select the six item and the Select All check box is checked error occurs.
If I remove the Select All Option and they select all six items no problem no error.
It is only when the select all is pressed.
I've tried putting a filter on the visual itself and removing the "BLANK" row and that did not help.
Any suggestions?
I've triple checked the data and there are NO blanks in the data NO nulls nothing.
4 Replies
kdixon5490 , check out which column has a blank value. May be replace that with NA. Or remove from visual or report level
if you are using this one -https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/#_Hierarchical_slicer
kdixon5490 - That's odd, You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".I've triple checked the data and there are NO blanks in the data NO nulls nothing.
Hi kdixon5490 ,
Based on my test using the data with blank value in the latest version of Power BI Desktop, the "Select All" also works well. You may upgrade the Power BI Desktop, and then try it again.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
