Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have an issue when filtering numeric column which has numbers and blank values in it.
Problem is that when using the filter to show only 0 (zero) values, also the blank values will be shown. Selecting/deselecting blanks in the basic filtering has no effect. In advanced filtering applying "is not blank" works however.
Also in basic filtering, if all the values are selected ("Select all") and then clicked one by one (deselecting them) so that 0 (zero) is the only value selected, then matrix shows zero values correctly. Also in this case selecting/deselecting blanks show in the matrix as supposed.
Attach are screen captures of the issue. I have also reproduced it in a simple pbix file which I can send/upload somewhere.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.