Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Steps to replicate the behavior:
Step 1: Create the following 2 tables:
Table1:
Number | NumberName |
1 | one |
2 | two |
3 | three |
4 | four |
5 | five |
6 | six |
7 | seven |
8 | eight |
9 | nine |
10 | ten |
Table2:
Number | NumberName |
4 | four |
5 | five |
6 | six |
7 | seven |
8 | eight |
Step 2: Create a 1-to-1 relationship between the 2 tables based on the Number columns.
Step 3: Create a table visualization with all columns for Table1 and a slicer for Table2's Number column.
Step 4: If it's not already selected, select 'Between' for type of the slicer.
When you try to slice Table1's data and in the slicer you select data from 4 to 8, every datapoint from Table1 will be returned.
Another strange behavior is present, when you try to select data from 4 to 6. After slicing, 7 and 8 will be missing from the table, but 9 and 10 will still be present.
Please let me know any possible solutions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Anonymous ,
Accorrding to my test, the reason for this situation is that there is a blank value in the number column of table2.
The solution is as follows.:
1 add number column into "filter on this visual"
2 choose "basic filtering"
3 Uncheck the blank value
4 Results show normal
Best regards,
Community Support Team Selina zhu